Joni Mitchell’s Big Yellow Taxi. There is a mention of a taxi in it, but I think it’s better known by the opening line/chorus, “They paved paradise, and put up a parking lot.”
The Band’s The Weight:
“The Rain, The Park, and Other Things” by the Cowsills. A.K.A.: I love the flowergirl.
I was older than I care to admit before I realized that The Ballad of John and Yoko was the name of the song that went “Christ you know it aint easy/You know how hard it can be/The way things are going/They’re gonna crucify me.”
I think it was called “The Bus That Couldn’t Slow Down.” 
I just thought this deserved to be quoted.
Nothing more to add to the subject of the OP.-
Lest we forget…
“Sympathy for the Devil,” the Stones. Pleased to meet you/Hope you guessed my name!
“Dialogue, Parts 1 and 2,” Chicago. Doesn’t have anything remotely resembling a refrain until the very end, when they start singing We can make it better/We can change the world now until you just want to stab yourself.
“The Spirit of Radio,” Rush. Title could be confused with any of various phrases/words that Geddy chirps with varying degrees of regularity- i.e., “The power of music,” “Honesty/Yeah, your honesty”
“Teacher,” Jethro Tull. Hey man, what’s the plan/What was that you said…
“N.I.B.” by Black Sabbath.
Your love for meee has just got to be real
Before you know the way I’m going to feel
I’m going to feel
I’m going to feeeeeeuuuulll
(Also a contender for dumbest pseudo-chorus of all time)
Great thread!
-Moody
“Teacher” by Jethro Tull? Maybe it’s just because I first became aware of this song was from a mix tape from my uncle with the songs listed, but I don’t see this one. Now “For Michael Collins, Jeffrey, And Me” on the other hand…
I’m not seeing “Long Cool Woman In a Black Dress” either. There’s not a regular chorus but I never had a problem associating the title with the song, even when I was little and didn’t really understand the song.
But two songs I know from Mott the Hoople where the title has little to do with the lyrics or chorus are “Dath Maybe Your Santa Claus” and their cover of Doug Sahm’s “At The Crossroads”.
The word “teacher” sneaks by early in the verse; it’s never used in the refrain, where, traditionally, the song title resides.
If you didn’t know the name of this song, you might possibly deduce it, but only after weighing what the entire song was about.
Live’s “Selling the Drama” (“Now we won’t be raped—Hey-ey-ey. Now we won’t be scarred like that…”)
Bohemian Rhapsody
And, may I offer as the antithesis of this thread:
Why Don’t We Do It In The Road? 
Ding, ding! I think we have a winner! Or loser, as the case may be.
I’m with Dung Beetle and Beadalin. Led Zep song titles are hard to tie to their songs. I’ve looked at entire CDs of theirs and not recognized a single title, but then listening to the CD revealed that I knew almost all of the songs.
A lot of Green Day’s songs are like this. In addition to “Good Riddance” (“Time of Your Life”), there are
"Longview":
Bite my lip and close my eyes
Take me away to paradise
and “Basket Case”:
Sometimes I give myself the creeps
Sometimes my mind plays tricks on me
“Flagpole Sitta” by Harvey Danger. You know, that one that goes - “Ahhh… I’m not sick, but I’m not well… And I’m so hot… 'Cause I’m in Hell…” I can never remember what it’s called when I hear it on the radio, and it drives me nuts.
Billy Joel’s “Scenes From An Italian Restaurant.” I’m surprised how many people have heard this and don’t recognize the title. I think it would be obvious.
Pink Floyd’s “The Happiest Days of our Lives.” Also known as the middle bit with the helicopter in the middle of “We Don’t Need No Education.” :rolleyes:
“Total Eclipse of the Heart” by Bonnie Tyler, known to some as “Turn Around.”
“A Simple Desultory Philippic (Or How I Was Robert McNamara’d Into Submission” by Simon & Garfunkel. This song has no chorus but you’d know if you knew it. “I’ve been Rolling Stoned and Beatled 'til I’m blind…”
And a better antithesis to this thread is The Safaris doing “Wipeout.” It’s got, um, one lyric. 
“Surrender” by Cheap Trick.
(“Mommy’s all right, Daddy’s all right, they just seem a little weird”)
“What’s the Name of That Song?”
From the very first musical recording I ever purchased (hey, I was eleven, cut me some slack), I submit “More Than Words Can Say” by Alias. Commonly known as “I Need you Now,” for obvious reasons:
I need you now
More than words can say
I need you now
I’ve gotta find a way
I need you now…
“Touch of Grey” (aka “I Will Get By”) from the Grateful Dead is another. And I never could remember the name of The Pretenders’ “Brass in Pocket.”
From the '90s:
“Counting Blue Cars” by Dishwalla. Usually known as “that song where the singer calls God a chick.”
“Possession” (…and I would be the one / to hold you down / kiss you so hard…) by Sarah McLachlan (though only for casual radio listeners - Sarah fans from my highschool years seemed to know everything about her, like her blood type and first boyfriend).
“Standing Outside A Broken Phone Booth With Money In My Hand” by the Primitive Radio Gods, which doesn’t have a chorus and is, like “Tom’s Diner,” known for its “do-do-do-do-do-do” more than its lyrics.
Then, of course there’s “Lick My Love Pump” by Spinal Tap
Then there’s the Rupert Holmes song with the same title but just about everyone calls it “The Piña Colada Song”.