There has been a “startling collapse” in public satisfaction with the NHS, according to a major public survey.