I'll just quote what the Rust team said about their code of conduct, because it's spot-on: "The Rust community doesn't subscribe to the notion that there's a dichotomy between intellectual discourse and kindness."
That's pretty much it. If your team considers those two mutually exclusive, you're headed for trouble. It might not be today or tomorrow, but you will pay for it long-term.
A thick skin is necessary, but the point of psychological safety is that it must be normal and expected for someone to make mistakes and to be wrong. It happens inevitably. How teams handle it is the important part. The most successful teams I've experienced are those where someone can say "yeah, I messed up, I'll fix it" and the team sees this as a necessary part of a team's long term function.
That means nobody on the team says "I told you so," and that team members can disagree intensely without making it personal or emotional.
The big problem with "without making it personal or emotional" is that the people most guilty of making disagreements personal or emotionally charged are also least likely (in my experience) to recognize that they're instigating. These people are toxic without realizing it themselves.
I definitely don't mean that. More like, there are always tradeoffs. There is cost/benefit in being truthy just as there is cost/benefit in being harmonious. Each has it's own type and you get to choose which make more sense for the situation, team, etc.
I don't think you can "have it all" so much as you can choose to set the tradeoff point somewhere in the middle rather than at the extremes. For example, in the Rust code of conduct example, it sounds like they have decided they want a nice mix. This will cost them though. Maybe the cost is as small sending $some_multiplier_above_1 the amount of emails between the team because things are worded more indirectly to not offend and therefore more disambiguation has to take place. If their team instead committed to be as direct as possible, the could spend less time on follow up emails but now they'd probably turn of or drive away some good folks from the team who decided they didn't like all the directness and send of urgency.
Personally, I like a nice mix. I think it is just worth being clear with myself it is a mix and not two independent things where you can have an infinite supply of each.
I believe you may be misunderstanding something about the idea of psychological safety. I can't think of any definition of "harmony" that has anything to do with psychological safety.
I suspect a confusing of "harmony" as a situation in which people don't speak up out of not wanting to hurt someone else's feelings with "harmony" where everyone is comfortable speaking their mind as they know their comments won't be taken as an attack or unnecessary criticism.
The second definition of "harmony" is actual harmony. The first is anything but.
edit: or if it does hurt their feelings, that they'll be able to express that safely, and you'll all be able to resolve the conflict.
If you have to pick, your team sucks.