The dull answer is that if we all stopped watching or reading or listening to the work of scum, there'd be fuck all films, books and music left. Distance obviously helps - Dickens was a grade A twat to women, but he's been dead 150 years - but currently, really, separate the art from the artist if at all possible.
Also, see House of Cards? BBC did it in 1990 with Ian Richardson. Much better, and the leads not getting Weinsteined because he died years ago. Watch that instead.