These things go back and forth. The ancient Greeks thought women were insatiable sex fiends and that no single man could please a woman, so to the men back then, sex with women was a chore; hence the rampant homosexuality and bisexuality. (To the point that one of the Roman Emperors was considered downright WEIRD for being a strict heterosexual.)

I rather suspect that attitude came from the transition from matriarchy to patriarchy. The women in a matriarchy expected their needs to be met, including sexual needs, and so in the transition to a patriarchy such an expectation got "spun" by the men as women being insatiable sex monsters. Hence stories of creatures like mermaids that would fuck a man to death.