English folk song rarely seems to rollick in the sex, so to speak. Rather it mostly sniggers at it (as in "the Threshing Machine").
Thompson's "Lass at the hiring fair" is I think quite erotic.
But the medal I think needs to go to a tune title "The lass is pissing brandy".