Help us please! Finances and baby

I'm making this anonymous to protect my hubby, Thanks in advance 

This wasn't a concern originally when we started to plan for children. I decided to stay home, as I saved up a year or two worth of salary and put it in an account. Now I use that money to help pay for bills, while my husband goes to work.Although we share in expenses my husband feels as though he is officially the "Breadwinner".

He is upset about his job but l feel like I can't help him and it's ruining both of our peace of minds. While he is unsatisfied with the low pay and high hours that comes with being a teacher, he refuses to look for jobs outside of academia. Right now he teaches philosophy at 3 community colleges because no one is hiring full time philosophy professors in our area, and he is unwilling to look for jobs out of state. He did a job search one of these days and applied for a full time, tenure track position but he didn't get the job. He didn't get the job because he has only been teaching for 2 years and they wanted 10 years of experience. He was really upset and now he refuses to look for more work. I am the type of person that sees the baby as a HUGE blessing and trusts the future. But my husband is worried about the future, which is fine but he needs to take action if he wants to improve his salary. 

Ladies, he told me he is writing some obscure book on philosophy, which I think is great, but he is writing a book expecting it to make money. I know about publishing and I have been there. If he publishes, he would get 3,000-10,000 loan that he would have to pay back and make approx 1.25 per book. Hardly enough to make money, especially off a philosophy book in today's twilight/50 shades society. He isn't allowed to make a textbook or something for his class so it would have to be for outside audiences. I am afraid because his motivation drops when he gets rejected and I want to build a real family with him. Of course I never mention anything about the lack of pay in publishing to him because I don't want to be unsupportive, but I wish he would be realistic. I am not sure how to talk to him about finances. Please help. 

He already woke me up at 3am again. I can never sleep because he wakes up at 3-4am jumping out of bed because he is so anxious about money. It's not fair. I am pregnant I need to rest

Thank you