Sex is at its most base a mechanical act. Penis in vagina, nerve endings stimulated, semen released, sperm go to egg. There's nothing mystical or magical about it.
Yet at the same time, men build palaces, write poetry, kill other men in their tens of thousands, simply to have it.
The urge to reproduce is innate and overpowering unless you have very deep religious convictions(and even that's not often enough to deny the sexual urge) or are a homosexual. The effects of it are also so desired, status, pair bonding, children, etc...
We live in an ostensibly secular society, that doesn't put undue spiritual or metaphysical significance on human body functions, yet even so-everyone from feminists to conservatives, to tiktok addled teens understands just how significant sex is. Which is why sexual morality is so hotly contested, why men devote such large stretches of their lives towards getting pussy and why women are-when patriarchal restraints are lifted, both so wildly promiscuous and choosy about who they fuck willingly.
If you're motivated by sour grapes, I think you'd want to have faith in artificial means of reproduction. Or the pursuit of immortality as such. So that we might live forever. All the same, I do not think there will ever be an act both physical and emotional, spiritual and base that generates the same emotions that sex does in us. Because it is after all, integral to what we are.
That is beasts without hair.
We are not angels, pure and sexless. As much as some of our best wish to be, but cavorting apes in the trees.
It gives me grief that it is so, but we are all tied to our desires and urges. from the ugliest incel to the chad of chads. Every man who is not a faggot wants to fuck.