It strikes me as necessary housecleaning.
It's pretty clear to me that sexual harassment and assault are far more common than people realize, and it follows from that that there are plenty of people who are victims who have not come forward for one reason or another. I've see plenty of female friends warn each other about "dangerous" or "creepy" people, and while to me it seemed distressing that they would have to do that, to them it just appeared to be "the thing to do." I got the impression that dealing with this stuff is far more of a daily reality for women than most men realize.
This sudden influx strikes me a exactly what you'd expect to happen if we were to start fixing the problem: the barriers to coming forward drop, and all those pent up accusations come out at once. Think of it like a wound-up spring, all those Bill Cosby types who got away with it for years and accumulated a huge number of incidences suddenly getting decades of comeuppance at once.
In the future, hopefully, when someone does something like this the first time they will be called out and disciplined right away – so that the problem does not continue to escalate. That will not only decrease the overall number of bombshell mass accusations, but also make it harder for abusive men to arrive at positions of power. Someone like Weinstein would get in trouble once and have his career stall out before he became one of the most powerful people in Hollywood, and the less powerful he is the less able he would be to pressure women into sex. Someone else who isn't an asshole would simply take his place.
So on the whole I'd say this is a good thing. Not a pleasant thing by any stretch of the imagination – like, I used to like George Takei and Louis CK, just like I was fond of Woody Allen films before I learned about what he'd done – but it is something that more or less had to happen at some point.