Orgasms while sleeping are commonplace. Among guys. Usually referred to as “wet dreams”. I see no reason why women shouldn't have similar experience. Quite a number of recent surveys indicate that many women do not orgasm during intercourse. Even Sex and the City did a thing on it. The many jokes/stories about women “faking it” have been around since the thirties. Look at Anais Nin’s letters. She was heavily into comparing “manual” orgasm and coital orgasm.
I recall Allan Pease’ quote.
“Men don’t fake orgasm, no one wants to pull a face like that on purpose.”
Then there is Woody Allen.
“Jewish foreplay” Two hours on your knees begging…”
“In my next life I want to live my life backward. That way you end up as an orgasm.”