Do most women not want to have anal sex?

Tried it once. Yes its painful but it feels good if your partner is good enough to do it. I even asked him if its dirty down there (i feel awkward but he likes to try it, and out of my curiousity i let him) but no, he let me smell it by his finger and it smells like a bubble gum hahahahahhahahahahaha