I think there is a romance about Yorkshire - maybe started a long time ago (a bit like the romance that people put around Cornwall and Scotland). Which makes people want to come here and magically their entire life will be 'made better'. (Also the opportunistic thing to benefit from the differential in house prices).
Truth is, if you're unhappy with your life, changing the background scenery won't make a jot of difference. And however great the schools and pretty the scenery - you won't ever truly belong (my stepmother found that out even after over 30 years here she was never really One Of Us but maybe that was more down to personality and Yorkshirefolk have very good radars, maybe).
If I was OP I'd address the issues where I was, rather than imagining that moving to somewhere that looks pretty on the telly, would suddenly make me and everyone in my immediate vicinity, somehow different...
My husband is fine here but he is unusually resilient to digs, and slightly on the charismatic side which means he charms the pants off people with his disarming smile. So it depends on the Southerner as to whether they ever really integrate (and in the posher villages they're all outsiders anyway, to be brutally honest so OP would fit in fine - I only heard one other local accent in the playground when picking my kids up from a certain school they used to go to in a snobby estate village).
I always think there is a danger of destroying the thing you admire, when you superimpose yourself on it. Come here on holiday. Spend your tourist dollar. Get it out of your system that way.