In my experience it's the opposite of helpful, because it's actually a lot easier to reach consensus on whether someone's being an asshole than on whether they have violated the code in the document.
It’s a very helpful tool for establishing opaque power structures, because it allows those with real power to pretend that they are simply following some legalese document instead of doing as they please.
The fact that this behavior, which would violate most CoCs ever written, came from the top tells you everything you need to know.
Code of Conduct cannot stop someone from doing something.
It’s just a document.
However, in this case, the presence of the code of conduct has made it trivially easy to point out the language as wrong in a way whoever wrote this for Zig cannot refute.
How is it working? The post is still there, referring to people as "losers" and "monkeys". Was the author of the post chastised? Have they edited the post and apologized?
Heh. You've rediscovered Critical Race Theory, which was a graduate-level theory about how rules/laws are systematically applied to minorities/the powerless, and not applied to the powerful/project leaders.
Holding the powerful to the law is unfortunately, a separate issue to whether it's worth it to have written rules/laws in the first place.
A CoC could still be better than no CoC, even if it fails to rein in abuse from the top.
Not the same thing at all. There's consequences for murder, absolutely none for not abiding by this CoC; as clearly seen by the fact the posted remains as is.