As I said a little while ago, I don't think there's a majority for any position. There are folks in several places on the spectrum. Whereas the people were allowed to vote yes or no to Brexit.
I don't think there's much value in being in the EU, which at best is a frustrating bureaucracy, and at worst is trying to create a European superstate. If it was simply a tariff-free trade zone it would be a useful thing, but that isn't on offer.
It's useful for the EU that the bad solution they offered May won't wash. Maybe they might be more constructive as a no-deal won't be good for them.