The best answer I can think of is it depends, and it’s always on a case-by-case person-by-person basis.

It’s like finding out that a famous painter whose art you really like did a murder suicide.

In some cases, that could actually add to the allure, even though it’s horrible.

But in the case of a musician that used their musical career to coax underage girls into performing sex acts for them, like the singers of the Lost Prophets, it’s a lot harder to separate the art from the artist.