I think it depends on the person, what they’ve done, if they’ve been convicted and individual tolerance.
Many people shrug when they learn that John Lennon was an abusive asshole who used to beat his wife. Many more wilfully let Chris Brown back into the industry after how badly he beat the shit out of Rihanna. Even artists like Michael Jackson and R Kelly managed to avoid child molestation accusations for years, and likewise more people rushed to cancel 6ix9ine for snitching on the Nine Trey Gangsters than they did when he was convicted of doing inappropriate sexual things to a 13 year old girl and somehow only landing probation.
Then you have truly bad cases like Ian Watkins, former leader singer of LostProphets. The band had effectively been disavowed from the moment of his arrest.