My boyfriend is excited about me being pregnant but I'm afraid it'll wear off...soon...?

I just found out I am around 7 weeks pregnant. I'm 28 and already have an 11 month old whom I have struggled to provide for on my own (His dad abandoned us when he found out I was pregnant) so, I have been living with family and living off my UI payments and am applying daily to jobs. Well my boyfriend met me when I was 7 months pregnant. He is what you would call the strong, silent type. He is very ambitious but I fear sometimes that his goals are unrealistic and that he will end up settling for mediocrity. He is elated about me being pregnant. He wants us to rent a house, neither of us have our own cars and he works at a restaurant. I'm definitely not judging him because I don't have two nickels to rub together either but I am focused on CAREER type jobs that have lucrative salaries, benefits, daycare options...etc. I just fear that when I'm further along the realities that a new child is on the way will overwhelm him. he had applied and went through the process to become a cop but was denied. And before that, he got laid off a Census Bureau position. He has an associate degree. But I just don't know why he isn't pushing to get a better job. I am so fearful that this will be a huge struggle for us both and I just want him to understand the seriousness of having a child.