No, he obviously wasn't, but that wouldn't have made any difference to him if he was. He got a medal for bravery so I don't think that any amount of hassle would have stopped him doing his job properly, or keeping a person's private business confidential.
IF Nicola's family did agree to the police giving out such personal information, then I presume that they now believe that she isn't going to be coming home, because
[even though someone who might be having mental health problems and/or problems with drinking too much alcohol (possibly caused by those mental health problems - or vice-versa), and/or sadly have difficulties with their peri-menopause, they should not feel at all embarrassed or ashamed about ANY of those things, unfortunately many of us still would, because we know that society appears to be still made up of many, very judgemental people]
if Nicola is still (hopefully) alive and well (at least physically), they would know that she would almost certainly hate the whole world knowing about her private life. If I were Nicola - and under the circumstances that we now think we know about - I would not ever want to come home now.
Of course Nicola's family have all my sympathy for the awful situation they are in, particularly of course the children. But I think that if they were advised to agree to to the police telling us all this very private information, then I do personally question that advice. Surely if the police and family had kept quiet, then if anyone else had made claims about Nicola's recent mental health history, the police could have continued to claim that they couldn't tell us anything because of confidentiality, and the family could have just said that those claiming that Nicola has those problems, were just trolls.
We all know that the internet is littered with trolls, so most of us would not be surprised by that. We, the general public, no matter how genuine our concern may be, have no given right to know any of these details. I cannot see how us knowing these things could possibly help in the hunt for Nicola.
Further up in my response here to @MrsDanversGlidesAgain, I complained about people being judgemental, and yet here I am being judgemental, but I do think that it is ok to judge organisations - as long as there is at least some form of logic to the judgement, and as long as the person judging keeps an open mind as to whether their judgements are fair or not, and are willing to hold their hands up, and apologise if they are later proved wrong. I don't think we should ever judge individuals until they have been proven guilty, usually through the law courts, because that can ruin a person's life without there being any validity to the judgement at all. I would not have given my judgement on this Police Force, if it had not already been an argument in the public domain. But it is, and I am just as entitled to my opinion as anyone else is.