Seems like a great opportunity for any pilot! I think if he didn't take it, he'll be kicking himself in the butt for the rest of his life. I hope you are a supportive spouse and afford him this chance that others would give their eye teeth for.
(I'm a female, have been a wife, and am involved in aviation. As crazy and unstable as this industry is, you have to be supportive and remember if he's happy---you'll be happy. You DON'T want to be the one to talk him out of it since his current career is in your comfort zone. If you don't afford him this golden opportunity and his comfy regional gig implodes he will never forgive you and that won't be a good thing for your marriage).
Best of luck either way!