There’s plenty of songs that people think mean one thing but actually have a different—sometimes darker, sometimes not—meaning.
The first that pops to mind for me is the first song* I ever learned to play on guitar:
Sympathy for the Devil
The title might make a person think, “Oh, there go...