Families of people with poor mental health will bear the brunt of chaos caused by psychiatrists resigning as experts warn the public system is failing patients.