I have not experienced a choice like yours, but I did move from my family & friends in Chicago, to Oregon in 1979, with my first wife. We were 20, and by 21 we had a baby & a new circle of friends & were very happy. Family was 3000 miles away, but our future felt like it wasn't in Chicago, so there were no regrets.
5 years later, she and I were to go our separate ways. Our 4 year old began her years of joint custody living first with me in my new home in Hawaii, and the next year in Santa Fe NM with her mom. Both her mom and myself found new circles of friends, life changing new career opportunities, and the continued sense the neither of our futures were back in Chicago... so outside the difficulties in that marriage, no regrets on a second significant move away from friends, and in my case, further from family...
Besides an 18 month stint in New York City where my sign career was spawned off my architectural background, my next move was to Santa Fe to continue another 6 years of co-parenting without my daughter having to have her childhood friendships disrupted with annual moves. I can say once again for me, that there was that same sense of exhilaration for all the possibilities. I can also say I was an extremely social creature making friends easy and often...so in each move I left behind a network of friends that was significant to me, (and in fact that I could return to & find largely intact) but the adventures ahead of me always were always more compelling then the familiarity & security of the valuable relationships I chose to move away from...
Those last 2 moves (or 3 with the shorter NYC experience) were done without a significant other making the trip, which was of course one more of many very different elements from the fork in the road that you are facing.
For me it was perhaps an easier decision to make alone, but there was times I felt alone as I rebuilt a new network of friends after creating a sudden vacuum around myself where there had previously been a full and busy life with friends, in bands, jobs, kids schools, athletic camaraderie, and all the support that comes from having a place in a community, but looking back I wouldn't live those choices in my life any differently.
The last move was back to Maui 15 years ago, after my daughter was 16 & my ex was moving her to Austin. Again, the network of friends, community support, social opportunity & the comfort of cruising along in a well established routine was sacrificed, and the excitement of new and different choices, opportunities and possibilities was presented instead. Once more, I must say... no regrets, as i found myself an opportunity to own & become somewhat successful in a sign business, remarry, buy a home, and build a new network of friends and family. I have an awesome relationship with my kids, my siblings, and my mom (and dad until 2001) and being thousands of miles apart never interfered with the core of those relationships, but it certainly presented me with new experiences and opportunities that have undoubtedly shaped my life.
Last thoughts... if you and your wife wouldn't consider this an unacceptable option, do you think a solo trip to put in the first 3 months at this new job, before the total commitment of moving the family is required? I don't know if there is a home to sell, and 2 existing jobs to quit, but it could be a more cautious scenario to see how the new job works out for awhile before putting all your eggs in that basket...
ok, another one last point... I don't know your ages, and I know this sounds real obvious... but make sure your wife is 1000% on board, because your current surroundings IS very much a part of the status quo that your current happiness resides in, and you will be disrupting the external aspect of that for sure, so you both need to be more exhilarated about change, then regretful about sacrifices,
Good luck with your decision!