It's an instrumental, but the dour Fyt by This Mortal Coil always brings the breath of an apocalypse with it. It always reminds me of the clanking industrial landscapes, like the horrible coal-stained beach at the end of Get Carter.
<Tried very hard not to post a whole bunch of Aphex Twin tracks esp. from SAW and SAWII which can be quite harrowing listening at times. Plus what many of the tracks are actually called is open to interpretation>
I will however post this piano cover of Vordhosbn by Leila:
That then reminded me of this, a track from a little point'n'click puzzle game no less. Come for the lonely piano, stay for the cautiously uplifting oboe:
I struggled to think of any actual songs with words in them, because I think as soon as you add a human you start to lose the desolation factor. But I figured Arc of a Journey by the late great Broadcast fits the bill, the thoughts of a satellite orbiting an Earth from which all human life has been extinguished.
Jury's out on whether you'd consider Liz Fraser using words exactly, but Musette and Drums sounds like the sort of spell that would end the world: