"You Will Do Extraordinary Things" perfectly captures the sadness of the moment: your world is dying and the only hope for your child is blasting her off in space.
Other:
The song "That's Really Super, Supergirl" by XTC refers to Supergirl and name-drops kryptonite and the Fortress of Solitude. Even though it is a Break-Up Song, it's still pretty cool.