“Creeque Alley” by The Mamas & the Papas is another famous one.
“And no one’s getting fat except Mama Cass”
“Over The Hills And Far Away” - Led Zeppelin (also Houses of the Holy)
“The Battle of Evermore” - Led Zeppelin (4th album “ZOSO”)
Nobody asked, but this is supposedly the longest song title. Never having heard it, I can’t say if these are in the lyrics:
“I’m a Cranky Old Yank in a Clanky Old Tank on the Streets of Yokohama with my Honolulu Mama Doin’ Those Beat-o, Beat-o Flat-On-My-Seat-o, Hirohito Blues” - Hoagy Carmichael
“Love You To,” “The Ballad of John and Yoko,” and “Tomorrow Never Knows” - the Beatles
Yeah, Zep’s got a number of these. In addition to the ones already mentioned:
“Immigrant Song,” “Hot Dog,” “D’yer Maker,” “Celebration Day,” “Bron-Y-Aur Stomp,” “Four Sticks,” “The Rover.” Then you have one like “Fool In the Rain,” which has the word “fool” in the lyrics, but that’s it. And there’s probably a bunch I’m forgetting.
Lots from New Order.
“Bizarre Love Triangle”
“True Faith”
“Round and Round”
“Blue Monday”
“Thieves Like Us”
This Time of Night"
…and many more. None of the songs on their Technique album include lyrics in the song titles.
“The Headmaster Ritual”
“How Soon Is Now?”
“Rusholme Ruffians” … all by The Smiths.
Lots of songs by Stone Temple Pilots: “Creep”, “Big Empty”, few others I’m missing. STP were the king of “title not mentioned in the song”.
“New York Mining Disaster 1941” by Bee Gees.
“Train in Vain” by Clash.
“Good Riddance” by Green Day
“Prophet’s Song” by Queen
“Under the Bridge” by Red Hot Chili Peppers?
“Tom’s Diner” by Suzanne Vega
How about songs where the title is mentioned once?
nm
ninjad
It’s probably easier to list the ones with the title in the lyrics. A project for a rainy day. 
The 11th untitled song by R.E.M.
Don’t worry; SFW.
Rush’s “Anagram (for Mongo)” doesn’t either. The album this is from was released 25 years ago this week. 
“Flagpole Sitta” by Harvey Danger
“Iris” Goo Goo Dolls
“No Myth” Michael Penn.
“Stairway to Heaven” does. 
That one is in the lyrics: “what if I was Heathcliff, it’s no myth…”
“After the Gold Rush,” Neil Young
“Bass Strings,” Country Joe & the Fish
"B-Boy Boulabaise, The Beastie Boys
“Come Softly To Me,” The Fleetwoods [They sing “come softly,” but not the full title]
“Epistle to Dippy,” Donovan
“Fingertips–Pt. 2,” Little Stevie Wonder
“Gimme Little Sign,” Brenton Wood [Consistently sings “Gimme some kinda sign”]
“Hymn to Her,” The Pretenders
“The Inner Light,” The Beatles
“Land of 1000 Dances,” Chris Kenner/Wilson Pickett/everyone else who covered it
“The Last Resort,” The Eagles
“Love Ballad,” L.T.D.
“A Lover’s Concerto,” The Toys
“Motorpsycho Nightmare,” Bob Dylan
“Mystery Train,” Little Junior Parker/Elvis Presley
“Night of the Living Bassheads,” Public Enemy
“One Chord Wonders,” The Adverts
“Positively Fourth Street,” Bob Dylan
“Queen Jane Approximately,” Bob Dylan
“A Quick One While He’s Away,” The Who
“Randy Scouse Git,” The Monkees
“A Sort of a Homecoming,” U2
“Space Oddity,” David Bowie
“Subterranean Homesick Blues,” Bob Dylan
“Tubthumping,” Chumbawumba
“Viva La Vida,” Coldplay
“Young Turks,” Rod Stewart
“The Deer’s Cry”, also known as “St Patrick’s Breastplate,” mentions neither deers nor breastplates.
“The Ballad Of Jed Clampett” by Lester Flatt & Earl Scruggs does use the word Jed, but not Clampett.
“Seeing Julie” by Kaskade makes no mention of Julie.
“Peace Frog” by the Doors. Most listeners not owning the record probably think it’s called “Blood In The Streets”.
“Atrocity Exhibition” by Joy Division.
Kathy’s Song by Simon and Garfunkel (just put that on right before I opened this thread, actually!).
“Under the bridge downtown / Is where I drew some blood / Under the bridge downtown / I could not get enough / Under the bridge downtown / Forgot about my love / Under the bridge downtown / I gave my life away”