There is no such thing as "cancel culture". It is an ultra right (and mainly white supremacist) invention. For hundreds of years many voices have been "cancelled" by the white male population in power. Non-white, non-heterosexual, until most recently non-male and, in the Western world, non-Christian views have been sidelined, marginalized, and not allowed in the mainstream. Now that people who don't represent those mainstream views have had enough of those who preach them--they don't want to hear speeches and opinions about bigotry and intolerence (racism) and they use their democratic right to shout down those same voices who have been responsible for repression (or cancel culture if you insist on using that term) for centuries.
I agree with your overall position, but I think you have the wrong impression of what "cancel culture" means. Cancel culture is the tendency of some fans to want to completely boycott any creation involving an actor, writer, or whatever who's been accused or found guilty of sexual assault, bigotry, etc., e.g. Bill Cosby, Kevin Spacey, Orson Scott Card, J.K. Rowling, etc. There is a valid argument to be made that it's an overreaction, that you can reject a person's negative views and actions while still finding value in their creations. For instance, Alfred Hitchcock treated women horribly, but we can separate the art from the artist and still appreciate the brilliance of his films. Not to mention the fact that any movie is a collaborative creation of hundreds of people, and it's unfair to the rest to boycott their work just because one person involved in the film turned out to be a sexual predator or something. If the work itself is intrinsically racist or otherwise harmful, like Song of the South or Birth of a Nation or Gone with the Wind, then it's best to move it out of the "timeless classic celebrated by all" category and put it in the "viewer discretion strongly recommended due to problematical content" category, but if the problem is just with one actor or creator and isn't reflected in the work itself, then the work can still be appreciated independent of the person in question.
Of course, I wouldn't be at all surprised if the right wing had corrupted the term and applied it too broadly to demonize the whole concept of holding people to account for their actions. But they did not invent the term "cancel culture," nor do they have a monopoly on it. I often see it argued against on Facebook by novelist Adam-Troy Castro, who's anything but right-wing and indeed is often quite outspoken in demolishing right-wing thinking, but is also a hardcore film buff who laments the tendency of many people to close their minds to anything that even reminds them of a problematical individual, even if the work in question bears no taint of the individual's crimes or hatreds beyond the mere fact of their participation.