If an orgasm was necessary to conceive, then all women would be able to have orgasms during sex. I'm not so lucky unless I get, ahem, an extra hand of help, but I have a good time either way so I don't worry about it.
I don't think anyone has ever done any studies on it, so there isn't really an official yes or no from science.