I have struggled with this a lot in recent years. For example, I grew up with Ender’s Game as my favorite book. Orson Scott Card is a racist/misogynistic/etc POS, and it has tainted my view of his books. People are experiencing this with J. K. Rowling right now.
I like to think I can keep the artist separate from their art, but it’s hard.