I think it’s a stretch, or perhaps an oversimplification is more correct, to say it’s mostly about sex. I think it’s far more about the mysteries of love, of which sex (in the song) is a relatively small part.
I don’t care what it’s about. It’s a beautiful song. I love the K D Lang version. Most here would cuss her too but she’s one of my fave vocalists.
If you look at the lyrics in the 1988 version, it’s... pretty heavy on the sex part.