I have yet to see a well-defined playbook for mitigating the Twitter Eye Of Sauron turning on a person that has a better success record than chance. Different things have worked for different individuals (including issuing a public apology, see https://www.vulture.com/2020/12/influencer-apologies-2020-sh... for a collection of them and the result).
It may be the case that cancellations are too circumstance-specific to say what works and what doesn't.
It may be before the online mobs grew large enough, but Tim Hardaway dealt with his homophobic comments well enough to convince everyone that he had a change of heart, and was not just trying to manage the fallout (https://www.washingtonpost.com/news/sports/wp/2017/02/16/ten...).
It may be the case that cancellations are too circumstance-specific to say what works and what doesn't.