We have never met anyone who had low self-esteem at the moment of orgasm.
Sex is for pleasure, a complete and worthwhile goal in and of itself. People have sex because it feels very good, and then they feel good about themselves.