David Bowie's "Space Oddity" tells the story of an astronaut who cuts off communication and floats into space. The BBC used it extensively in their coverage of the 1969 moon landing - an odd choice considering the lyrics.
The TV show Cheers was nearly canceled after its first season, but the theme song, "Where Everybody Knows Your Name," was very popular. To satisfy viewer demand, the theme was made into a full song and released as a single.
"Come Dancing" by The Kinks was inspired by the older sister of Ray Davies, who would make guys take her out dancing and spend their money on her, only to send them home frustrated with just a peck on the cheek.