It's a leading question, not begging the question. Begging the question would be "sex is fun because of X, and X always happens because sex is fun"
I'm going to quote Woody Allen. The context is too delicious to pass.
"But isn't sex messy?" "Yes, but only when done right."
Is sex fun? Most people might say "Yes", but not quite 100% of the population.