Hollywood used to have a pretty good way of dealing with scandal. It's often called the doghouse.
If an actor had a scandal, the way it worked was that they'd have a brief period of humiliation. They'd lose some work - maybe their next project would be cancelled or recast - they'd have some bad headlines, Jay Leno would crack jokes about them for a week or two.
And there was a way back. If your scandal was substance related you'd check into the Betty Ford clinic. If it was racism related you'd contact Jesse Jackson and he would give you something to do. And after about 12 to 18 months your career would get back on track.
Obviously some people would be impacted more than others, and some careers never really recovered. But it would take a huge scandal like OJ Simpson being accused of murder to make someone permanently unemployable. Short of that, there was a path to redemption.
The problem I have with recent year cancel culture is that it tries to make people permanently unemployable for having the wrong opinions. JKR is probably too big to fail, but you can see the way it's hit someone like Glinner.
One reason why I don't give a fuck about NG is that he loved cancel culture as long as he thought it would never come for him.