I've always subscribed to the ol' "love the art, not the artist" credo
I think it really just comes down to whether or not you're able to compartmentalize in that way. I'm able to for the most part, partly because I've always been aware that most of my heroes were at least *assholes* (though a child molester is obviously something completely different). Also, I'm just selfish when it comes to art- it's one of the main things that gives life meaning for me and I can't really live without it. It's as simple as that. I'm sure some folks would accuse me of valuing art over human life and TBH I wouldn't necessarily argue with that. But at the same time, there's definitely been a feeling of betrayal when I've heard the news about Woody, Louie and Roy Harper (who was acquitted FWIW), because they're all among my favorite artists who were accused of being sexual predators.
But as you pointed out, the more important issue is whether this ability to compartmentalize is going to be seen as a character defect in the years to come. Unfortunately, it looks like that'll be the case- you can already see it happening. It's going to divide people and given the state of the world, that's the last thing we need right now. And sadly it's our fellow liberals who seem to fall into this trap the most easily. And that will be our undoing. If we stop interacting with people who share our values about the things that really matter simply because the art or entertainment they happen to enjoy was made by "bad men", we're truly ####ed.