alt Hacker NewsOrson Scott Card is one of the best selling sci Fi authors of all time, and has won the hugo and nebula award multiple times, and has been translated into 35+ languages. I think you would be pretty hard pressed to show that his writing isn't compelling to many people.
a lot of that happened before his views were more widely known. much like jk rowling. a lot of people have written both best-selling authors off as bigots; this is just a matter of fact. they may be financially comfortable but their standings have been irreparably harmed by their own statements.