S.W.
I work as a career consultant for an outplacement company, helping people find new jobs after a layoff. Sorry if this sounds cynical, but...
Do NOT worry about anyone but your family when deciding on which job. Decide what is the best work and life opportunity for him and your family and then just do it. It sounds like the job in WI is clearly the better opportunity - advancement, money, family needs - and simpler without the move.
There is no way of determining long-term company stability, anymore. So don't even try to determine that.
Your husband could talk with the woman who helped get him the job and explain how his decision is the best for your family. I very much doubt someone will hold his decision against him.
I've previously worked as a recruiter, for professional positions. I've had people not show up for their first day, or show up but them quit within days or a few weeks. People need to do what is right for them. Companies have no "loyalty" to their employees anymore.