A mental health trust was criticised for repeated failings and told there was “no faith” in it turning things around.