I think you need to:
- clarify why he has changed his mind so categorically
- sit down together with a large piece of paper divided into 6
Headings:
*Advantages of staying where you are
*Disadvantages of staying where you are
*Non negotiables in your potential new home/area: -eg garden/balcony/outside space; 2 bedrooms; kitchen diner ...or whatever. Train station/links; good bus service; local hospital or whatever
*Pros of moving - eg manageable garden; new area; quieter area; seaside; new interests/opportunities or whatever
*Cons of moving:- eg away from friends/family; loss of present clubs/interests
*Notes/thoughts/considerations
Use this to have some really detailed conversations about it all. Listening to each other, thinking, returning to the subject, thinking, Give yourselves eg 6 weeks /1 month to do that. Then look again at where you both are and how you are feeling
This worked for us 6 years ago. In the end we didn't move but ripped our house apart inside and put it back together again, knocked down walls, redesigned things, and the garden and felt like we had a new house. Actually we didn't do that , it was builders, (!!) but it was worth it for us. We don't regret it!