It's always hard to uproot the family and move, but you have to look at this. You have the opportunity to do what so many people wish they could, advance without a degree. That just doesn't happen. You've recieved some excellent advice here and I can only reiterate it at this point. I like the idea of renting your existing house out. Causes you to live rent or mortgage free at the next place. You don't have to move two hours away, maybe an hour away? Closer to family, not horrible to work. I too believe that God works in wonderful and mysterious ways and for this to just pop up out of the blue like it did could mean that this is the path that you are to take. Just think of how good it would look on a resume. I assume you know what this job is all about and that there would be no surprises? You are obviously good at what you do, the guy thinks enough of you to offer you the position, the family is behind you, you said yourself that it may help the present prayer request situation, it's not THAT far away that you couldn't see family often and it's a big bump in pay which gives your kids a full time mom. In the words of Charlie Sheen... WINNING.
My present job was a choice that I had to make. I work for what was a very small company that was purchased and moved from California to Alabama. The building looked like a building that was bombed in WW2, they couldn't find a decent work force, it was difficult to get into the markets that they wanted to get into, etc. I had a good job as a supervisor of a drafting department for a growing company and I got a call from my present boss that he wanted me to come and work for him at this little company in Alabama. I would go back to being a detailer again. Now my situation was a no brainer of sorts because I got to work from home. I still had the uncertainty of leaving a well established and very busy company for this little "experiment". You may not think it was much of a choice compared to what you are faced with but, believe me, it was. Well I took the offer and now, almost 9 years later, the company is growing like mad and we;ve become a major player in the field that we were trying to break into. I'm making way more as a detailer than I ever did as a supervisor, and on and on. My enticement was working from home. Yours is the position and what you are able to do once you have it. Every time you change jobs, it's a gamble, a chance you take. Sometimes it works, sometimes it doesn't. Sometimes these opportunites are stepping stones to the next one. I could write all day about my own personal situations through out my career, every job offer, every job I took or didn't take. Let's just say, it's a faith walk. Have faith, believe in your own abilities and face this head on. You were offered this position for a reason. Maybe its time to find out what that reason is?