Space colonization is simply jumping third or fourth steps removed from the dream of making our Earth more livable and more ecologically diverse, or learning how to build and make an acrology.
From that perspective, it's no wonder why people think it's a waste of space, because they saw no meaningful purpose. Meanwhile, we're doing the opposite of terraforming Earth, by making it more unlivable everyday.