The Wreck of the Edmund Fitzgerald by Gordon Lightfoot. Not happy.
There’s probably some in musical theatre. Sondheim’s score for Assassins comes to mind. Again, not happy. Some of it SOUNDS happy, but it isn’t of course.
“Blow Me A Kiss” Alice Cooper. It’s off the “Brutal Planet” album and it’s about Colombine.
Another one from the same CD is “Pick Up The Bones” which is about a man collecting his family’s body parts in, I think, Sarajavo. Alice had seen someone on CNN doing just that, putting the bones in an old pillowcase after a massacure.
Liza by Loudon Wainwright III about his childhood friend, Liza Minelli. Tonya’s Twirls, also by Wainwright, about Tonya Harding (and not what you might expect). My Soul’s In Louisiana by Otis Taylor is based on the story of a lynching. Someone Saved My Life Tonight, based on Elton John’s thoughts of suicide. Smoke on the Water by Deep Purple, based on a fire they witnessed.