A friend of mine had that song played at her wedding. Weird. In the program, they had some vague idea of “ending” their age of innocence by growing up & being married people, but then added, “Our home will be a place of innocence.”
They’re now divorced.
Not to mention that, at first, it seemed (to me at least) that the song was about me, and it turned out it wasn’t. 
From the Buffy musical episode: Once More, With Feeling!, Tara’s love song to Willow “I’m Under Your Spell” is first played as a happy love song, talking about how in love she is with Willow, and then later, it’s revisited, this time a lament when Tara discovers that Willow has actually been casting amnesia spells on her to make her forget disagreements they had, thus literally putting Tara under her spell.
What about the George Jones song “Hotter than a Two-Dollar Pistol”. The first verse appears to describe his car, and the second makes it clear it’s the woman in the car who is so hot.
The song “Silhouettes” by many groups, the version I know by The Nylons. It starts out with a guy outside his girlfriends house, seeing two people in silhouette on the windowshade, hugging and kissing.
The singer loses control and rings the bell, intending to confront his girlfriend and her new guy, when “two strangers who had been two silhouettes on the shade/said to my shock, you’re on the wrong block!”
Chad Brock’s The Visit. The song starts with the singer explaining to his wife that he’s been seeing another woman who can give him “what you can’t any more”.
Then in the last verse you find out that he’s at his wife’s grave.
Not QUITE a song, but there is a Jodie in the Air Force called “Irene Irene”
Irene’s her name
She’s one of the best.
So every night
I give her the test.
She looks so pretty.
So sleek, so slim.
The moon is bright
the lights are dim.
I’ve seen her stripped.
I’ve seen her bare,
I’ve felt her over everywhere.
I handled her just as gentle as I could.
And when I got in her
I knew she was good.
I rolled her over on her side
Then from the back I also tried.
She’s just one big thrill
the best in the land.
She’s an F-16
in the Air Combat Command.
A number of the jodies we sing are like that, starting out vulgar sounding, with some twist in them to make them relatively innocent. Of course, some of them have some twist in them to make them even worse, it really depends on who’s calling the jodies. 
Running out of Ink by the Barenaked Ladies manages to go from sympathetic, to a feeling of triumphant smugness, to just plain depressing through the course of the song. This is mainly facilitated by the end of each “paragraph” with <something> me (i.e. I wish that it was me, and you can’t look at me). It’s actually circular as well as changing, it shows it by using the same “qualifier” in the first and last non-chorus stanzas.
I think I’m explaining it right, it’s just the feeling I get from it at least.
“Lola” by The Kinks seems to be about how the narrator meets a woman, but in the last line he finds out that it’s really a man.
I’ve got one. It’s called “Driving Her Home”. As the video starts, we’re looking at a late-thirtyish man in a car reflecting on his past. The scene outside the window is stark and wintery, as is the music. As we go along we see flashbacks to his first meeting with his wife. It’s all furitive glances and secret smiles and teenage awkwardness. Jump to several scenes of a happy life together; first kisses, getting married, buying a house, having a child, etc. The music brightens at first but eventually returns to slow, sad and somber. As the song fades, the POV sweeps up and out and we see the hearse pull up to a rural family cemetery. The man steps out and the family start gathering for a graveside service about to begin.
If I ever finish it I’ll post it somewhere.
One of the most disturbing songs to me that’s in the same vein probably with the shocking ending is the rapper- Immortal Technique’s Dance with the Devil.
If you want to youtube it, you’re welcome to do so, but it’s EXTREMELY graphic and filthy, and it is to this day one of the few songs that I can’t really listen to, yet consider extremely powerful. I still remember the first time i heard that song…
Moderator reminder: You’re doing fine, but just a reminder please not to quote entire song lyrics. Instead, quote a verse or two and provide a link to a site that has copyright rights and shows the full lyrics. If you’re confused, please see: Rules for Posting on the Straight Dope Message Boards, Post #3 is about Copyrights.
robardin, I’m leaving what you posted since you’re adding analysis of selected verses, so “fair usage” is probably OK.Raguleader, since it’s a jodie, I’m assuming there’s no one with copyright? So, this is just a reminder to future posters to please be careful… and considerate of the artists who created the songs.
Does he? Or is Lola merely glad he’s a man?
People keep bringing this up, as if those were the only lyrics in the song that made the suggestion that Lola was a man.
Well I’m not the world’s most physical guy
But when she squeezed me tight she nearly broke my spine
and
Well I’m not dumb but I can’t understand
Why she walked like a woman and talked like a man
and
She picked me up and sat me on her knee
and
Girls will be boys and boys will be girls
The implication is ubiquitous thoughout the song. It’s not just in that one line.
In Richard Thompson’s Don’t Tempt Me the narrator is mad that his girl is dancing with another guy, and dirty dancing too (“ban that couple, Certificate X”) - but we find out at the end that it’s her uncle.