To be fair, I loved the Beatles song Maxwell's Silver Hammer when I was, like, 5, and only realized what was going on (murder!) years later.

...but I do get your point / am pretty sure that's not the kind of songs you're referring to.

Yeah, I was thinking more of

Me And A Gun by Tori Amos, about her actual real-life experience of being raped at gunpoint

or Eminem's ’97 Bonnie & Clyde, which has a father singing to his small daughter after he has murdered her mother, stepfather, and half-brother

https://genius.com/Eminem-97-bonnie-and-clyde-lyrics

or pretty much any of the songs on Nick Cave's album Murder Ballads...