CNC is by far one of the most common sexual fantasies people have, especially women. Since chemically in the brain arousal is arousal, it makes very little distinction between fear and sex.

That's never going to go away, so the only sane response is harm reduction+safety In practice this means playing with people who you trust, using safe words and providing after care.

A LOT of sexual assault survivors have this fantasy, so those people need to take things slower and take extra care to avoid accidentally using it as a form of self harm.