I agree; I don't think he can come back and just carry on as he was.
I think if he came back with apologies and some kind of explanation (e.g. doubled down on the autism thing, or the 'bitches be crazy' thing) it might create enough division and confusion that it allows him to carry on his career, but with significantly less support and celebration.
I suspect that there will be more women thinking about coming forward and I strongly suspect Gaiman has been very, very busy trying to get in touch with all of them and beg them to stay quiet.