According to cognitive science only about 2% of thought is conscious - the rest is driven by the subconscious - so no, most people have little idea of what their actual motives are. It's the weapon, it's a part of the process, and yes, it feels physically good - but that's still not the underlying motivation. If you just wanted an orgasm, you could masturbate or go on a date or hire a hooker.

Ask a psychologist or a sociologist or a cognitive scientist. Honestly, YOU can be so ignorant about this stuff.