I think the collective “we” need to learn how to process new information when it comes to light about our favorite authors or heroes, and Gaiman qualified as such for many. We can’t all “know our heroes.” That’s not how it works. Some of us are lucky enough to actually know them, and that’s usually because it falls under “My parents are my heroes” or some such. But from there, the ability to actually be in a close relationship with someone you come to regard as a hero plummets rapidly.
In Gaiman’s case, people loved his writing and characters. It’s a hard thing to learn that in many cases, he was possibly pulling those stories from a much, much darker part of his being, but that’s not on his fans. Some insiders apparently knew about him but again, not everyone is an insider. That’s not on the people who didn’t know.
This is Gaiman’s s#!%-show, one of his own making, but it’s one that people have to process and that takes time. It’s not helpful shouting out “I knew there was something up about that guy.” Good for you, but it apparently didn’t help any of his victims. That’s just a form of scorekeeping in one of the worst games of the world - a kind of online gambling where you’re just betting on human misery. There’s no winner there.
This just has to shake itself out. Some people will divest themselves of everything he’s done. Others will hold on to what his work meant to them, as has been done with so many artists who’ve been found to been accused or have done terrible things. But people will not stop being inspired by others and calling them heroes and that’s a good thing, not something to say “yeah but you never know what they’re REALLY like.” Things will change, as they always do, what matters is what they mean at the moment, and how you process that going forward.