I think Enola Gay by Orchestral Manoeuvres In The Dark is a perfect example.

It sounds upbeat and fun but it's about the atomic bomb dropped on Hiroshima.

Some of the lyrics are incredibly powerful and I still get chills when I hear it.