I am glad you are supporting your husband. It will make his transition to the airlines a little bit easier. There are so many things you will have to consider, I will try and list some things you need to think about below. Also, remember that there is no pilot shortage and there never will be. This is a great myth.
I do not know what your financial status is but you will probably have to go back to work full time in order to suppliment his training and pay after training. Also, your husband can get a flexible part time job during training (if time permits). The best jobs are usually at the FBO's as he will be able to network with corporate pilots.
Your husband after graduation may have to instruct for awhile in order to obatain enough time get the the guaranteed interview or FO position at the associated regional / commuter airline. During the first several years of his employment he will not make that much money. The typical regional FO starts out around 20K/year (some places a little more some places less). Out of the 20K you will need to factor in all of your bills plus the following:
1. Unfirom, luggage, flight bag, misc pilot supplies
2. Parking fees (not always paid by the employer)
3. Crashpad / hotel (if commuting to work)
4. Dining out daily (you can't always take food with you)
5. Travel fees (not all travel is free)
6. FAA Medial Exams
HOME LIFE:
You also need consider the quality of life you and your children will have. If your husband decides to commute that will cut into the time he has with you and the kids. If you live where he is based that can save money and allow him to spend more time at home. This is especially true if he is placed on reserve (very common for new hires). Also, be prepared to move. The company can change your husband's base at their discretion and most will pay some moving expenses if he is forced to move. However, if selling of house is involved you may be forced to eat a loss depending on the market and how long you have lived in it.
There are several websites that I will list below that are a good source of info and support from the wives of pilots.
Professional Pilot Families
FCAPA - Families of Commercial Airline Pilots Association
Don't be afraid to send me a PM if you have any questions....