Anal sex

Does anal actually become pleasurable ?? My man told me he wants to do it just in the heat of the moment and I was like uhhhh Idk I don’t really like the thought of it,,, and he felt really bad and he was like “I will never ever force it I only want to if you let me” and he was super nice about it and I’m considering it since I know he wants it and I kind of ruined the moment lol, I’ve never done it so like i can’t knock it till I try it but I don’t hear very good things about it so I’m not sure how to make it feel better ??