IMO it was much more about Kirk’s inherent irresistibly to women than actual sex. In TOS the women are practically fainting at the sight of Kirk. That’s because Kirk is a Mary Sue TV trope but perhaps more relevant, Kirk was very obviously Roddenberry’s stand-in for himself.