Oh, you definitely need to check out some of Kate Bush’s songs. She has many that are very erotic but subtle, such as “The Saxophone Song” with the lyrics “There’s something very special indeed, in all the places where I’ve seen you shine…it’s in me” and “L’Amour Looks Something Like You” with the lyrics “All in order, we move into the boudoir…I’m dying for you just to touch me, and feel all the energy rushing right up-a-me” but she has others that are not so subtle.
Not quite what you’re looking for, but this is another one that’s quite erotic, to me. Forget the flowers and poetry, just get on with it dammit!
After midnight on Saturday nights my local NPR station runs “Blues Before Sunrise”, which focuses on very, very old blues recordings. About 90% of the lyrical content seems to be sexual euphemism. I’m guessing it’s really 100%, I’m just not hip to that final 10%.
“Sex Machine” and everything James Brown ever uttered.
“I’m Your Man” and everything Leonard Cohen ever uttered at least if you’re fairly weird.
“Sex Dwarf” Soft Cell, cuz were else am I ever going to get to bring that up?
And then there’s Big Black’s “Songs about Fucking” although while all rock and roll is about sex it’s possible none of those songs are.
And of course the '20-'30-'40 bluesy songs are thinly veiled songs about fucking but at the moment all I can think of are thinly veiled songs about drugs. Oh, wait…“Backdoor Man”
“The men don’t know but the little girl understands…” Indeed.
Also Je t’aime… moi non plus, ibid, 1968. Rumour has it he originally recorded it with Brigitte Bardot, as they had sex in the studio. Then re-recorded it with Jane Birkin who says the sex was simulated.
Relax, don’t do it, Frankie Goes to Hollywood, 1983, which seems to be urging gay men not to climax (yet).
My Caribbean grandmother used to sing a risqué calypso called, I believe, You get on top. A hotel employee is listening at the door of a honeymoon couple and hears things like “You get on top / don’t make noise / shut your mouth / I am your husband you know” (then the roles reverse, lest you think it sexist). This would be from the 1930s/40s or even earlier.
What about the Song of Solomon?
4: 16 Awake, north wind,
and come, south wind!
Blow on my garden,
that its fragrance may spread abroad.
Let my lover come into his garden
and taste its choice fruits.