> France discovered this the hard way when they implemented their first wealth tax
Citation needed (for a solid study, not right-wing propaganda from CNews/Libération). From a quick cursory look, it appears the French government had no problem raising taxes when the taxes were higher, and that the previous governments who reduced taxes for the rich setting blame on public debt have in fact increased public debt over and over. (disclaimer: i'm not an economist)
France's government expenditure is 57% of its GDP according to th OECD. It's probably an all-time record in the annals of global economic history in peacetime. It's more than the late Soviet Union spent around 1985-1990 according to the IMF / World Bank.
The 2025 deficit ran at around ~150 billion euros. The Zucman wealth tax would raise 25 billion in the most optimistic projected scenario (so, one sixth of the deficit at most). This is the very best case as projected by its proponents - there's a decent chance receipts would be significantly lower than that.
You're absolutely right that right wing parties did not, and almost certainly will not, solve any of these issues. Neither will a wealth tax. In my opinion, this is only solved in a bang.