I dealt with that as a kid with Roald Dahl because he was super antisemitic, but he also wrote amazing children’s books. I guess for me it depends on how much they put such ugliness into their work. Lovecraft, creative as he was, had no problem being racist in his writings and I just can’t read them even though I love the mythos. Dahl didn’t do that.
Card and Rowling are somewhat different cases because they didn’t start by writing terrible things, but they got to the point that their ugly beliefs began to seep into their books.