Sorry, I’m spoken for.
Revtim
This belongs in the depressing category but I’m surprised how this one got overlooked:
"Spaceman" by Harry Nilsson
I wanted to be a spaceman, that’s what I wanted to be,
but now that I am a spaceman, nobody cares about me.
From 1972 I believe. Also a small portion of it can be heard in the movie “Contact”.
You’re right, there ought to be more positive songs about space flight.
If you’re just looking for space songs that are interesting to listen to, though, try Earth Below Us, Circling Skies, the Purple People Eater, and Space Monkey.
Eight foot two
Soli Blue
Eight transistors in each shoe
Has Anybody seen my gal?
… but when I woke
She was gone
Eighteen Billion miles Away…
Oh, wait.
I guess that’s not really positive…
I thought that they were angels but to my surprise
They climbed aboard their starship and headed for the skies
Singing come sail away come sail away
Come sail away with me
What about “Mr Spaceman” by The Byrds?
Hey, Mr. Spaceman
Won’t you please take me along
I won’t do anything wrong
Hey, Mr. Spaceman
Won’t you please take me along for a ride
All righty then. Let’s get serious here.
What about:
Fireball XL-5
Fireball XL5
I wish I was a spaceman,
the fastest guy alive
I’d fly you ‘round the universe.
In fireball xl5.
Way out in space together.
Conquerors of the sky.
My heart would be a fireball.
A fireball.
Every time I gaze into your starry eyes.
There’s “Martian Love Song,” and even “Hey Mister Spaceman” by the Byrds. Lest we forget, there is also “Urban Spaceman” by the Bonzo Dog Doh Dah Band.
Doesn’t “It’s worse than that, it’s physics, Jim!” come near the end of the song?
I wouldn’t call this a positive space flight song. After all, they’re “boldly going forward, 'cause we can’t find reverse!”
I believe you, and have given this matter some thought myself. I think the reason this is so is because science and art are two things that just don’t mix, by their very nature. They are polar opposites in what they demand of a person’s sensibilities and intellect. Think about it: how many good writers are also good at math? How many scientific or technical people that you know also have finely-tuned tastes in art, cuisine, literature, etc.?
Not that such people are unknown, but they are truly rare. As someone who once attended engineering school but now makes his living as a writer, I can bear personal witness to what I stated above.
To be more specific, I’d say a lot of artists (at least the ones I’ve known) are antipathic because they perceive science, with its emphasis on structure and repetition of results, as a fundamental repression of the intuition that is the heart of most artistic expression. On the flip side, many scientists reject all but the least abstract forms of art (such as architecture) as so much frippery; what value can something have if it can’t be quantified?
It’s early, and I can’t think of anything specific except “destination moon” by They Might Be Giants but I’m almost positive they have some pro- space travel songs.
See also: the b52’s “there’s a moon in the sky (called the moon)” does “planet claire” count? I’m sure they have others too.
What about Starship Trooper by Yes? I can’t remember the words, or even what it was about, but I don’t think it was depressing.
Gee, I’m oodles of help…
Yup, that’s right. At the end the lyrics are frantic and twisted together before the final slow finale.
I submit Moxy Fruvous - *You Will Go to the Moon *
(All)
Orbiting Rondelle
(Dave on lead)
You will go to the moon
You’ll probably be heading there soon
Someday flowers will grow there
But first you’ve got to go there
Oh, You will go to the moon
(ooo, you gonna get it)
You will live in the stars
Your backyard will probably be Mars
You will ride a crater scooter
And eat off your computer
Oh you will live in the stars
.
.
.
Some years ago, Kenny rogers had a song, Planet Texas, that sounds pretty positive. Sample stanza:
Their shootin’ irons shot laser lights and their spurs was anodized
Bandanas caked with stardust and their jeans was pressurized
Well they handed me a halter and said, “Tighten up the girth.”
But before I hit the saddle we were miles above the earth
And I mean miles above the earth
DD
“Sleeping Satellite” by Tasmin Archer?
I blame you for the moonlit sky
and the dream that died
with the eagles flight
I blame you for the moonlit nights
when I wonder why
are the seas still dry?
don’t blame this sleeping satellite
I dunno, Lizard, that sounds like a bunch of stereotyping to me. Many of the scientists I know are also interested in art and music–some to the point where they made a very difficult decision about which career to pursue. Most of the scientists I know have a greater appreciation of art and culture than the average non-scientist, 'cause we’re all over-educated intellectual elitists. I don’t want to deny your personal experience, but at the very least I definitely don’t think it’s fair to lump scientists into the same category as engineers, who are much less likely to have a liberal-arts education. (In most universities, the engineering school is separate from the school of arts and sciences, and requires its students to take fewer humanities courses.)
And my friends who are artists who are very interested in science and positive about it. Then again, I guess if I knew an artist who was very anti-science, they probably wouldn’t stay a friend for very long, so there’s definitely a selection effect!
It may just be that it’s easier (or perhaps, more interesting?) for artists to make a negative statement than a positive statement about anything. I mean, if we just did a straight-up tally of songs that are positive about love vs. the somebody - done - somebody - wrong songs, we might conclude that musicians think love . . . er, is not a good thing. (Every negative word I put next to love “love” created a song lyric from the Eighties! See! Proof!) Perhaps we should not be surprised that musicians also dwell on the negative side of science.
Anyway, here’s a non-negative song about space travel, in honor of the late Mr. Johnny Cash:
“I fly a starship
Across the universe divide
And when I reach the other side
I’ll find a place to rest my spirit, if I can . . .”
Benson, Arizona from Dark Star isn’t negative. Nor is it positive. It’s more sort of wistful.
“Beep! Beep!” by Louis Prima
“Higher and Higher” and “Floating” by the Moody Blues.
Polycarp, more and more these days I’m beginning to believe that C. P. Snow’s treatise on the Two Cultures is outdated.
There are scientists and then there are uncultured people. 
Isaac Asimov used to write (frequently) that all scientists are expected to recognize and appreciate Shakespeare but that English professors would be insulted if asked to explain the second law of thermodynamics.
The number of writing scientists - both fiction and popular science books - seems to be at an all-time high. And a good many of the books by scientists I’ve read have made artistically cultural references.
(OTOH, when John Brockman acted as agent and got a large number of scientists million-dollar advances for books a while back, rumor hath it that the results were such badly-written piles of crap that only a few of them ever got into print and the whole line of books was canceled.)
It’s still rare in my experience outside sf to find artists who truly understand and appreciate science. They exist, but the difference is that it is in no way expected of them, while scientists are thought to be inferior nerds if they don’t know “culture”.
I’m more on Lizard’s side on this one.
How about Godspeed, John Glenn? There’s two versions of the song, BTW, one was released after Glenn’s first flight into space, the second was updated after his flight on the shuttle a few years ago.