You and your wife discussed the pros and cons of this new position -- right? You both made the decision to go for it -- right? Good!
Worst case scenario: you quit after a few weeks/months and find another so-so local trucking job.
Best case scenario: you stay with the company for 1+ years. Your experience will open up some great opportunities for you--be it regional/dedicated/local if you decide to move on.
No matter what, you can still talk daily to your wife and kids during the week. Better check that cell phone plan of yours and change it appropriately!