I think that the most widely accepted definition of "cancelling culture" is suppressing someone that has opinions different than yours. For example you can cancel a comic that has different political views. Opposing to that, when you have someone representing you, either a voted politician or hired attorney, it is not cancel culture if you disagree and want to be represented by someone else.
What if a comedian loses his audience because views of his come to light that his audience doesn't support? It's no longer profitable for him to go on tour, or for studios to offer him roles on tv, etc.. Is that cancel culture or not? I'd argue that it's cancelling, but not the "bad" kind.
If you say it's not cancel culture when a majority of people change their mind about someone, then you're saying that almost by definition cancelling is when a small minority of people have the power to deplatform someone who missteps. So, it's not accurate to say that "the left is ok with cancel culture" (for instance) since only a small group of people are going it who are not representative of the larger population.
Ask the same question: what if people don't like the local restaurant food (new chef puts too much salt) and they lost the patrons? Is that cancel culture? No. Cancel culture is when you want to close the restaurant for everyone when the owner's daughter refused to date you versus not eating there because you don't like the food, but you don't interfere with others eating there because they like the food. It's "I don't buy" vs "close them down".