The mass resignation of public psychiatrists in NSW is expected to hugely impact the state's mental health sector and advocates fear beds will have to close.