There has been a lot of handwaving about how people largely aren't affected by the change and "if you don't adopt neopronouns you're disrespectful to LGBT" (which is a false dichotomy, BTW) and whatnot, but seeing how the CoC change has not been reverted or amended in any way I certainly do not consider this resolved in any way.
What seems to be happening here is a pattern that nowadays can be observed with an alarming frequency in politics: when people get up in arms about a decision that goes against their best interest, the response tends to be "oh, we probably didn't explain that well enough to you" rather than listening to the concerns of the people and admitting a mistake, followed by a lot of smoke and mirrors while waiting for the storm to blow over. And unfortunately that tactic seems to work most of the time.
With that said, for everyone who believes this CoC change won't have an effect on them or be the last move in the direction of social justice politics, let me add a small data point for you:
I had posted my stance on the CoC change as an answer to the original (now deleted) FAQ where it was deleted by CesarM right away. The wording was certainly confrontational, but I disagree that it was "rude" or "highly offensive" like some people claim. I then posted that text (with some minor changes) in the "about me" section of my profiles because I want to make my position known, just in case anyone cares. The general consensus (at least to my knowledge) is that we're free to post in the "about me" section whatever we want unless it "is likely to be truly offensive to large groups of seemingly reasonable people."
However, at some point the larger part of the text was silently deleted (from all of my profile pages), without any notification or warning. Hence I raised a question about who had deleted the text and why, and flagged that for moderator attention. That was 4 days ago (at the time of this writing), and I have yet to receive any response from The Powers That Be.
I believe it was CesarM who posted a (now deleted) comment saying something about how being called by specific pronouns is a human right and they will defend it. Only to have some moderator or company employee go ahead and censor someone's free speech (which is an actual human right, BTW). So, good job there. What was it the CoC said? No bigotry?
Edit: The flag has now been declined with a canned response ("doesn't require moderator intervention"), so I contacted support as the next step.
Edit: Two weeks later: still no response.