Husband wants me to quit my job to raise kids and come back later

I'm a woman in my mid-30s working as an administrative employee. My job offers pretty good job security, but the salary is around minimum wage. Work-life balance is okay, though I sometimes have to work weekends. Commute is a bit long (1 hour by public transport, 20 mins by car). We moved closer to my husband's company (he put in a lot of money for this, and we both agreed considering investment and future plans). Our families live far away, so we can't get help from them (though they are financially stable). My husband works for a big corporation. Now that I'm pregnant, my husband thinks childcare is more important than money, so he believes it's better for me to be a stay-at-home mom until the kids are grown. He wants me to be there until the kids are about 9 years old. I also really want to be there for the kids right now. My husband said I can quit and be a SAHM, or take 5-6 years off and study for civil service exams or a professional qualification. But that's not an easy thing to do in reality. It's not that I think civil service exams are easy; it's probably because I studied for them for about two years that he wants me to try again. This is a bit all over the place, but this is my situation. I have a lot of worries about what the best choice would be. I'm writing this to hear other people's stories and opinions.