“Alex Chilton” by The Replacements.
My Boyfriend is in Killdozer (Young Fresh Fellows)
“Coda: Maybe If I Sang Cole Porter” - Susan Werner
“Fake Bjork Song” - Liam Lynch
Nerf Herder has several songs like that - Van Halen, Courtney (Love), Jonathan (Richman), and Pantera Fans In Love.
I had posted Life Is a Rock (But the Radio Rolled Me), but then saw that the OP wanted titles. Sorry. I got nothin’.
Checked iTunes
Frampton Brothers: Juliana (about Juliana Hatfield)
Paul Simon: The Late Great Johnny Ace
Chuck Berry: Roll Over Beethoven
Frank Zappa: Stevie’s Spanking, about his guitarist Steve Vai
Led Zeppelin: Boogie with Stu (features Ian Stewart on piano)
Colonel Claypool’s Bucket of Bernie Brains: Buckethead
Derek Trucks Band: Frisell
Ike Willis: The Foreigner from Boston – this scores two, and it also name-checks Godz, Styx, and Kansas
Team Sleep: King Diamond
Stone Temple Pilots: MC5
Acid Mothers Temple: Starless and Bible Black Sabbath
The Fall of Troy: Whacko Jacko Steals The Elephant Man’s Bones
Brian Eno: Zawinul/Lava
Tom Paxton “Phil” about the death of Phil Ochs.
Joni Mitchell’s “Willy” is about her relationship with Graham William Nash.
The Righteous Brothers - Rock And Roll Heaven (a list of deceased stars)
Kate Bush - Blow Away (Minnie Riperton, Keith Moon, Sid Vicious, Sandy Denny, Buddy Holly, Marc Bolan)
Paul McCartney & Wings - Rock Show (Jimmy Page)
George Harrison - Pure Smokey (Smokey Robinson)
John Lennon - Oh Yoko; God (Bob (Zimmerman) Dylan, The Beatles)
Three Dog Night - Never Been To Spain (The Beatles)
Steely Dan - Hey Nineteen (Aretha Franklin)
I’m sorry, I wasn’t awake enough when I made this post. I didn’t notice until it went through that the OP was looking for TITLES, not references. Sorry about that. I should go back to bed now.
Tom Paxton also wrote “Crazy John” for John Lennon, way back in 1976
“Hi, We’re The Replacements” by They Might Be Giants
From Country music playlists
I Try To Think About Elvis by Patty Loveless
Elvis & Andy by Confederate Railroad
and a self-referential selection from the Fab Four
The Ballad of John and Yoko by The Beatles
…and I Won’t Be Your Yoko Ono* by Dar Williams
*reminds self: the meaning of the word “musician” is both broad and generous.
Neil Sedanka’s “Oh Carol” about his highschool girlfriend Carol Klein,who later became Carol King and wrote “Oh Neil.”
Talking New Bob Dylan Blues by Loudon Wainwright
Blind Lemon Jefferson By Nick Cave & The Bad Seeds
Another one from Tom Paxton Did You Hear John Hurt
“R.E.M. Is Air Supply” - Peach of Immortality
“Loretta Lynn’s Lincoln” by Josh Turner
“If Ole Hank Could See Us Now” by Waylon Jennings
More obscure:
Jazz saxophonist/composer, the late Don Lanphere, had a song called “I Remember Clifford”. Alas, I don’t remember Clifford, but Don told me who he was once, twenty-some years ago. I think Clifford was another jazzman from before my time.
Nerdcore rapper MC Frontalot has a song called “Good Old Clyde”, referring to James Brown’s drummer, Clyde Stubblefield.
To be more precise, he’s Clifford Brown, one of the most noted trumpeters of his era before his sudden death at 25.