That's how it started, all those years ago
The push that got us climbing into space
Cynic beginnings, greed for big winnings
But look at all we've gotten from that race!

Two joyful ones:

My Planet's Child, by Echo's Children:
Oh, I come by it honestly if I am star-beguiled,
For if I am a rover, well, I am my planet's child
The very iron in my blood has wandered wide and far--
Forged and flung from the fire's heart that fueled a foreign star.

The Light-Ship, by Julia Ecklar, from the 1983 tape Minus Ten and Counting:

The opal world like a clouded pearl
Strung on a thread of light
(lyrics.wikia)(when I look out at the fog over the bay on my morning commute, this is a beautiful image)

Second, two ballads, both of which end up being by Leslie Fish, from Carmen Miranda's Ghost (1989):

Guardians

(What happens when you think you're going to die alone in space? Well, thank goodness, you're not alone, for one.)
“Come on, tovarisch!” this one urged, “you’ll make it, I don’t doubt. Show me some of those Yankee guts I’ve heard so much about.”
(genius lyrics)

Some Kind of Hero
(Do I cry? Yes, in fact, I do.) (It's hard to pick out a single passage from a story without giving too much away, but today my favorite stanza is:)
“Break out the suits,” said the captain to them, “For it’s dark and it’s airless and cold
But I swear I can get you all out of here safe Packed in to the Antelope’s hold.”
(genius lyrics)