Dante wrote, heaven has no laughter, because all humor stems from pain.
Rock and Chappelle's recent assaults violated an ancient human custom: the freedom of the jester to cause pain. Every joke has a twist in it, and the effort required to follow the twist is painful. If we like the content, we find the pain enjoyable, which is why we consent to the joker inflicting it.
Trigger warnings follow a similar misguided belief: that the world can be made safe. The world is a beautiful place full of light and love, but it's also totally ambivalent about any individual's well-being. Terrible things keep happening… and amazing beauty too.
I don't think it's actually a paradox, just two things not often combined: ambivalent love. Terrifying beauty.
Divine comedy trigger warnings.