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.