Please do you research very thoroughly indeed. A mid-life crisis is not a good basis for making such a major decision!
If you have school age children you must investigate the French school system in minute detail in order to decide whether you really want this for your children. If you think the British system is becoming narrow then it has nothing on the French system.
It is also very important indeed that you have a grasp of the language - there are many areas of France where the Brits are not welcomed with open arms, especially if they do not try and learn French.
The least of your challenges is working out the legal minefield of house purchase where the law is very different. Your real challenge is making sure that your decision is the right one for all your family in terms of employment prospects, education, the tax system, acceptance by your neighbours, which area of France, social life, being apart from wider family etc.
We have been down this route in the past and done masses of research, including many visits at different times of the year, detailed investigation of opportunities for the activities we enjoy in the area chosen, observing the subtle social cues to decide about the level of acceptance from locals etc. We eventually decided against it. We are both reasonable French speakers so had a bit of a head start, but still we concluded it was not for us.
My strongest advice to you would be to set apart a year for in depth investigations about the things that matter to you and your family before looking at properties. They look cheap and this can turn your head! You have to live in more than the house - you have to live in the general society. Renting in Britain need not be a "trap" but is a sensible option for many.
I would say to start with the education system and see what you think.
Some people do make the transition successfully and happily - many come back after a short while.
Good luck with your deliberations.