This article is from the SF references in music List FAQ, by Rich Kulawiec firstname.lastname@example.org with numerous contributions by others.
Australian band, did a song called World War III on their "Where is Hank?"
album. (They have connections with New Zealand band Dragon, through
"Reel by Reel" (the government can hear and record your thoughts);
"This World Over" from "The Big Express" which is a post-nuclear
holocaust cautionary tale. "That's Really Super (Supergirl)"
from Skylarking is about Supergirl's boyfriend becoming distraught
over her "other life". "Science Friction" (yes it's supposed to have
an 'r' in it) on "3D EP" (also on the CD version of "White Music").
XTC have released under their alter-ego "The Dukes of Stratosphear" (sic)
two fake-psychedelic albums, which do have a lot of SF-pointers.
Most obvious in the songs: "Bike Ride to the Moon", "What in the World ???",
and "Braniac's Daughter"
X Ray Spex:
"Genetic Engineering" from the album "Germ Free Adolescents" is about
the dangers of creating genetically 'superior' beings.
Yankovic, Weird Al:
"I Think I'm a Clone Now" from "Even Worse" (parody of the 60's hit
"I Think We're Alone Now", recently recut by Tiffany).
"Yoda" (to the tune of "Lola") and "Slime Creatures from Outer Space",
an original music-tribute to B-movies; both are from "Dare to Be Stupid".
Also "Attack of the Radioactive Hamsters From a Planet Near Mars"
on the soundtrack for "UHF", and "Christmas at Ground Zero" from