The first Buffalo Springfield album, Buffalo Springfield, featured a highly regarded Neil Young composition called "Flying on the Ground Is Wrong." If you heard only that title, you might think Young or at least the narrator of the song had some kind of objection to flying on the ground. But the chorus to the song actually goes:
But if crying and holding on
And flying on the ground is wrong
Then I'm sorry to let you down,
But you're from my side of town
And I miss you.
So flying on the ground isn't really wrong, and may even be totally permissible. There certainly doesn't appear to be any issue with flying on the ground, making the title almost a contradiction of the lyrics. It's as if the Beatles had called that song "Want to Spoil the Party."
(While we're on the subject of the Buffalo Springfield, that same first album originally didn't contain "For What It's Worth," the band's first and only hit, because it wasn't done in time. How close did it come? "For What It's Worth" was recorded on December 5, 1966 - the very day that Buffalo Springfield was first released.)
Are there any other songs like that, whose title suggests precisely the opposite of what the lyrics say? I can't think of any others. Can you?