It's parody of course, but "Double Team" by Tenacious D was basically written to be the epitome of this.

As for songs that are ostensibly serious, "Rock You Like A Hurricane" is kinda it. Everyone only knows the chorus so people are like, oh yeah that's just a song about rocking hard, the band is gonna rock us hard, right? Uh uh, that's a song about what to do when "the cat is purring," which, according to the lyrics, is "give her inches and feed her well" because "Lust is in cages 'til storm breaks loose"