I actually like a lot of classic rock (yes even Hotel California, that solo kicks ass) but there is a lot of bad classic rock too. What do you think the worst classic rock song is? What is the most overrated band or artist? I think Supertramp is mid at best, but Bob Seeger is truly dreadful.
You'll see it in more niche rock music. But yeah most popular rock music won't have it.
The only Rock music I can think of off the cuff that really has fun with lyrics is Cake and They might Be Giants and I'm not sure if either of them are actually rock.
TV On The Radio is an art rock band that have some great lyrics. I mean if we're talking about triple entendres, their song "Dirty Whirl" is about a sexual relationship with a woman, Hurricane Katrina, and the Hindu deity/goddess Durga. The first verse introduces it nicely
Right there is a triple entendre. Though some clever lyricism, the "murderess" could be a woman the singer is in a relationship with, a hurricane (likely Katrina given the release time of the song) or Durga. The mother of pearl lyric is particularly clever. Mother of Pearl, also known as nacre, is produced by some molluscs as an inner shell layer. And mollusc shells from the outside appear as a spiral, look at a snail shell for example. Just like a hurricane.