This is a good song. No one is saying that you should listen to it while in any type of altered mental state whatsoever. It's just a good song. The Wings recorded it in 1972 and it got pretty popular, though the BBC was turned off by some of its lyrics. Paul apparently had this to say about their concerns:
The BBC got some of the words wrong. But I suppose it is a bit of a dirty song if sex is dirty and naughty. I was in a sensuous mood in Spain when I wrote it.
Okay people, you heard the man, time for a sensuous trip to Spain.
Paul McCartney and Wings: Hi Hi Hi