Missed that masterpiece !
7 of them want to leave the EU, counting as 48% of the votes. We're at the breaking point and a year and a half after that, it seems obvious that EU didn't get any new support in the population. So it seems reasonnable to suppose more than half of the population wants the Frexit right now.
First of all only 77.77% people went to vote.
This leaves us pretty far from 48% of the people voting for a representative that wants to leave the UE.
Moreover your assumption means that people actually vote for any of the candidates only because they want to leave the EU, or that they wouldn't vote for them if they didn't want to.
I am pretty sure that a lot of people voting for both Marine Le Pen and Melenchon don't want to actually leave the EU. It is more about the ideology of both candidates than about the actual measures in their programm.
People voting for Marine often do so because they are racist, or blame the immigration policy for everything bad in France. This doesn't mean they want to to loose all the benefit they got from the EU.
Same goes for Melenchon.
My own feeling about the EU is that it was necessary to further develop our continent.
The first people getting benefits from it are all of the citizens. Globalization is a must today, and the EU and it's borderless region are a very good start.
This also means anyone can easily cross the border and go shopping in another country.
From the point of view of a EU company, all the operations made within the EU are made at smaller cost, and allow for a faster and less expensive market penetration. This has been proven to actually increase the GDP of most european countries.
Of course countries like France or Germany are actually among the ones benefitting the most from the EU.
However it also has increased influx of foreign investment in poor EU countries, making them develop faster.
Every year that passes makes the Union stronger. Maybe it will fail eventually, but I am convinced another Union would soon take its place.
I don't believe any second France will leave the EU in the near future.
Also about your point "that is what democracy is about". You are right but you are also wrong.
This would be true if we had been
living in a direct democracy for decades. Which would imply that people actually think about long term before chosing, and doing these choices carefully.
If we want more direct democracy we need to implement this carefully to avoid foolish choices from people that won't have to face the consequences.
When a president, or the government takes a decision many factors are taken into consideration.
Public opinion, but also how it will impact the country's future, if it is good or bad (from a moral perspective) and if it respects the constitution. Moreove any technical decision is made after length of analysis from experts of the matter. All of these factors are
unavailable to the basic citizens, preventing them from taking a well considerated decision.