This is not true, as there are certain cases where doctor/patient confidentiality is explicitly allowed to be breached - if you credibly threaten the practitioner or other people, then the duty of care changes. If you credibly threaten to murder someone, then a mental health staffer is entirely within their rights to breach your confidence.
Your own situation you describe, of course, does not appear to be one of those cases.
If someone said "you can trust me, except for this laundry list of things you can say in which case I'll have you locked in a cage and force you to take medication against your will" would you trust them? Because that's the reality of every conversation with a psychologist currently -- it's just not made explicit.
To put it bluntly, it's stupid to demand a practitioner ignore credible threats (stress credible) against their own life, in favour of some weirdly puritan moral theory. Practitioners are people too, with their own lives, loves, and foibles... and, frequently, their own mental illnesses. They're not any more disposable than the patients they treat. Just because you're interested in helping someone doesn't mean that you commit to do so even unto your own death.
> If someone said "you can trust me, except for this laundry list of things you can say in which case I'll have you locked in a cage and force you to take medication against your will" would you trust them?
Psychologists can't prescribe medicine or force detention - you're tilting at a windmill here. Psychiatrists can do both, though with some limitations on how they can detain. Similarly, credible threats are hardly a 'laundry list'.
This allows confidentiality within the law and does not deceive the patient.
Your third paragraph is very hyperbolic and taints the otherwise reasonable points I believe you made.
However, there is a significant second order concern with violating confidentiality. In future instances, the child may be less willing to speak "in confidence" with a psychologist.
In general, I would say "no." It's never okay for a psychologist to deceive their patients, or to experiment on people without their knowledge. Talking to a professional about mental health issues puts a person in a vulnerable position. When a psychologist abuses that vulnerability, it is an extreme betrayal that would make it less likely for the patient to be able to open up to anyone else about their issues, thus obstructing their ability to receive mental health treatment in the future.
Performing psychological experiments on people without their knowledge could similarly aggravate underlying psychological issues, with potentially serious consequences. This is some Nazi doctor-level shit.
Mental health issues are in some ways more problematic than physical health issues, because culturally we don't take them as seriously as "real" diseases. Too often our medical system treats mental health issues as a moral inadequacy, not a health issue. The fact that we even think twice about the question posed in the OP shows how seriously messed up our priorities are.