The Moody Blues did a whole album with mostly space related songs, To Our Children's Children's Children (1969)

From the opening, "Higher and Higher":

Blasting, billowing, bursting forth
With the power of ten billion butterfly sneezes
Man, with his flaming pyre
Has conquered the wayward breezes

Climbing to tranquility/ Far above the cloud
Conceiving the heavens/ Clear of misty shroud

And "Floating"

Bouncing about on the moon
Guess you'll all be up here soon
The candy stores they'll be brand new
And you'll buy a rock
With "The Moon" right through

And "Sun Is Still Shining"

Everything's turning/ Turning around
See with your mind/ Leave your body behind
Now that we're out here/ Open your heart
To the universe/ Of which we're a part