I think it's good, they are driving away some of their most popular content creators, those sites that don't censor will gain market share and those who do will lose it. If steemit.com starts banning everyone then I assume some enterprising anarchists/developers will have a Freemit.com STEEM plug in available which might not have many users at first but will gain them as people seek out the missing content creators.
A website that bans all its users will find it does not have any users.

Steemit should be fairly resistant because so many non-SJW types are here with lots of steempower to counter angry downvotes and most SJWs are way too stupid to figure out how to sign up and log in.