Who are "you guys"?
What evidence do you have that "we are emotionally invested"?
What is "the uproar", some posts on Twitter?
All of the above is weasel words to try to get around the fact that "cancel culture" really just translates to "people facing the consequence of saying unpopular things".
Rowling, who, again, was not "cancelled", faced criticism for her TERF views. TERFs are considered extremists, one that will get you kicked off of platforms for hate speech. This is because at its core they *very unpopular* in all kinds of polls.
Having unpopular views will get you backlash. That is on you.