My issue with cancel culture is what it prevents.
Yes, well-established people haven't seen themselves made destitute, cool.
What about the authors who can't find a publisher because something is considered 'risky' (we listed a few authors earlier in the thread whose work got pulled and was only later found to not be remotely what the naysayers said it was)?
The scriptwriters and directors who can't find a studio to take their project? If Taika Waititi wasn't really popular rn, JoJo would not have happened. If the same exact film had been proposed by a 'no name,' it'd have never happened. And JoJo almost didn't because even before it was out, Taika was weathering accusations of being anti-Semitic just based on the material of the film.
My worry of cancel culture isn't 'oh no someone I like might be ruined.' It's 'oh no, we're seeing fewer new artists.' Publishers and studios won't touch something that might be 'risky' (this is why it took so long for LGBT material to be more common place for YA: traditionally it got boycotted and didn't sell... THANKFULLY that has changed).
Art is about being able to present your view of the world. And yes, sometimes it is a shitty view and someone is a shitty person.
Other times it's stuff like JoJo Rabbit where difficult material is taken and shown through a different lens, but might in its elevator pitch not be seen as being as rich as it truly is.