I have a sort of in the middle opinion on this situation. If you were to commit a crime as a normal person, then your life will completely change. You will lose your job because most places don't want your association to affect their reputation with customers, some laws depending on your crime require you to inform neighbors of your bad deed, sometimes you're not welcomed back to the state, and society treats you differently in prison and out of prison. You get "rehabilitated," but life is fucked up when you're out of the cell.
A celebrity should be no exemption to this, and therefore should not get any special treatment. However, when you cancel a celebrity you lose the opportunity for education and making strides to help improve society. If these wrongdoers are shunned away into the darkest corners to never come out and rid of their existence instead of spending their life educating others about what they did wrong, why you shouldn't do the same, and helping to improve a cause. It is not suicide or locking a person away their whole life that makes them pay, but it is rehashing the guilt over and over again as they tell their stories, their wrongs, and educate the generations to come.
And the biggest downside to canceling a celebrity to the point of their own existence is that outside the victims a good number of people forget and move on with their lives. Anyone here remember Kevin Spacey? He is off the face of the Earth. Remember the hype of Charlie Sheen and tiger blood? Don't get me started on the Pauls of Youtube. I think of the #MeToo movement and how so many victims built courage to speak out, but we should evolve into a society where it's the criminals that are speaking of their wrongdoing. Cancel culture is like the thoughts and prayers that bring attention to an issue that eventually dies down and moves onto another issue with nothing learned or done of the last to better society.