It sounds like this player is asking to act out a sexual fantasy in your game.

If your game is not congruent with acting out sexual fantasies, then this is a HUGE red flag.

IMHO this is not limited to morally repugnant fantasies, it's about the comfort of everyone else at the table.