If by intended you mean driving away reasonable people that want to make software not get involved in politically motivated drama and moral panics then yes.
I like that we have a police and I've never committed a crime, but having a police around still makes me nervous since they have a lot of power. CoC's have the same effect, any reasonable person would understand this. They make contributing to a project feel more like a job and less like casual fun, and I don't really see why I would spend my free time doing a job for free.
Reasonable people will have no problem with mandating such treatment of all contributors.
Reasonable people won’t let their ego force them to oppose respectful conduct simply because it’s codified.
Reasonable people don’t believe their technical prowess entitles them to be dicks.
Seems reasonable, eh?