If all the Eurosceptics had voted for May's deal, it still wouldn't have had the numbers to pass. I think its fairer to lay the blame on the opposition parties who voted against it largely to try to create chaos which they thought would lead them to an election they could win.
Otherwise you don't have an opposition, and then you don't have much of a democracy.
It's the job of the government to secure the votes it needs for its policies, and conversely to propose policies for which it can secure the necessary votes.
That's democracy.
To the contrary, May’s government only tried to appease the hard-liners in her own party. Johnson has taken it even further in the same direction.
Like, the first vote definitely wouldn't have passed with them, but the third definitely would have.
Now personally, I think the Opposition should have voted for the deal, but the primary respionsibility falls on the government.
May’s majority including the DUP at the time was 7 (I think - this was after the defections to the Independent Group) so those 6 would have tipped it into a loss on their own.
I think that the real issue here is that there doesn't appear to be a majority in Parliament for anything (witness the indicative votes earlier this year, which found no majority for any form of deal).
I think that the reason many MP's are unwilling to let the UK leave without a deal are as follows:
1) It doesn't solve anything. You still need to agree what to do for a future relationship, from a much, much weaker position (only Council of Ministers agreeement for Article 50 deal, versus Council, EU Parliament and all national regional parliaments required for a future trade deal).
2) The EU will not allow any trade deals to happen unless the Irish border, the rights of EU citizens and the money issues are resolved.
3) The UK imports the majority of their food, and WTO tariffs are really high on food, leading to potential problems with food supply (remember that it's November, when not much grows in the UK).
Like, I don't doubt that some MP's want to remain in the EU, but for my money most of them have voted for some form of Brexit deal, with the exception of the rabidly fanatical members of the European Research Group.
Additionally, with respect to the terms offered by the EU: Yes, they will be worse than staying in the EU. By definition, if you leave a club, you no longer have access to the facilities of the club. It would make zero sense for the EU to do a deal for the UK that was better or the same as membership, because no-one would remain in the EU then.
I think that the citizens of the UK have been let down by many of their political representatives, but i don't believe that their desire to remain in the EU is the cause.