A new opinion poll has found that most British voters see leaving the EU as a huge failure for the country, especially around broken promises on NHS funding.