You are going to get a whole lot of different answers. Simply because there is no one answer.
There is also no separation between the physical and the mental. They’re one and the same. If you don’t feel physical pleasure during sex, you’re not going to feel emotional pleasure, and vice versa. There is nothing wrong with not feeling sexual pleasure. Sexual interest is not a binary all or nothing. It’s a scale from Asexual (not interested at all) to sex-addict, with most people falling somewhere in between. So any answer you get is going to be from different points on the scale, not necessarily close to where you are on it (very close if not completely asexual)
I fall somewhere close to asexual, but not all the way. I’m much more interested in the lead-up to it, first second and third base, so-to-speak, and rounding for home is just kind of a let-down after all of it. A part of that (not to get too into the weeds) is that I love performing cunnilingus, but hate receiving blowjobs, because I can’t fathom that a woman actually enjoys giving head, and therefore I can’t take any pleasure from it. But 80% of my sexual pleasure comes from knowing that I’m giving HER pleasure. There is no greater rush of endorphins than using fingers and tongue and then seeing your partner not able to walk afterwards because their legs are shaking too much.
THAT is far more of a sense to me; the mental. The actual act of intercourse is no different than masturbation; it’s what you do to empty your balls once the fun part has been completed.
People tend to look at me funny when I tell them that I don’t remember my childhood all the way up through highschool.
Certain big events in highschool I can remember of course. But for most of it is just vague impressions of “Yeah…I must have done that at some point, but can’t recall specifics”.
For Childhood it gets even more nebulous; again, a few things I clearly remember, and much of the rest of it I can’t decide if I actually remember it, or if I’m “filling in the blanks” from old photographs (the brain is funny that way…implanting a fake memory is pretty easy it turns out)
People have told me that that’s a reaction to childhood trauma, but since I’m kind of stupidly good at holding useless trivia in my brain, I just think I pushed it all out to make room for random facts about ancient history and star trek lore.