I think this song is about a (middle-aged) man who feels sexually inadequate. While his woman is a great lover (Snake charmer, worm tamer, serpent wrangler, mambo rider - all pretty sexual images when put in this context), the man cannot keep up with her - which becomes clear in the last verse: "Well my baby calls me the Loch Ness Monster/Two great big humps and then I'm gone"
I think this song is about a (middle-aged) man who feels sexually inadequate. While his woman is a great lover (Snake charmer, worm tamer, serpent wrangler, mambo rider - all pretty sexual images when put in this context), the man cannot keep up with her - which becomes clear in the last verse: "Well my baby calls me the Loch Ness Monster/Two great big humps and then I'm gone"