I've been married 14 years. Prior to my husband I had never before experienced an orgasm. I don't have one every time, but the honest truth is that I don't require one every time. When I have them, they are earthshaking. If- for whatever reason- I don't have one, it just won't happen at that time. I'm ok with that.
The worst thing is to be taken to the edge of one, and left there. That's like an hormonal avalanche.
My position may be a little odd in that I am very attracted to my husband, and I adore him, but I have little sex drive thanks to some screwed up hormones. If he doesn't initiate sex, I generally don't even think about it. If he hints at it, I am always accomodating, but it may take me a bit to get warmed up.
To answer your question, yes women do enjoy sex "that much".