While I really enjoy sex, I’ve never been interested in a one night stand. Is there something wrong with me?
Of course not.
Sex positivity isn’t about having all the kinds of possible sex. It’s about accepting people’s sexual choices, as long as they’re based in honesty, ethics, consideration, and consent.
One-night stands aren’t your thing. I’m positive you can find something that works for you and your (potential) partner(s).
Enjoy those things and don’t sweat the stuff that doesn’t do it for you.