If children were enjoying their books then, then they'll still enjoy their books now, and no children dont tend to, at the age of 8 muse on which author is with which publishing house, its completely irrelevant for them. All is needed if the books arent in the shop is 'no theres none here'. Of course what he has done doesnt directly affect a reader, how can it?
As for who is cancelled and who isnt, thats a question of hypocrisy, Michael Jackson still widely played, Bowie, Led Zep, Ziggy Pop (who has or had a radio show until recently). Some people are still lauded no matter what they might have done, others are put in the bin.
Their art or productions were still interesting or attractive to some.