A new survey reveals that 87% of NHS staff view the health service as weak, with confidence in government policies and leadership hitting new lows.