Not going back to work

My fiancé expressed to me he would rather me stay home and care for our child. I didn’t know how to feel. I almost feel guilty staying home and not working. But I know we would be better off because daycare is so expensive in my area, and although I have my degrees, I still wouldn’t make much after paying for daycare. The only thing I thought of, is if I work a day or two on the weekend or night if I wanted to. But then I wouldn’t see my fiancé ever and that would not be okay with me.My fiancé makes about $35-40 an hour and with his new job promotion he will be making $65 an hour for the next couple years so I know I will never make more then him. I just worry because this means we will have to move out of town soon, I won’t have any friends nearby, and I know this a lot of change fast. He already doesn’t get home till almost 7 now and I know when he starts the new work, it will be even later.. I’m just stressed out, and I don’t want people to think less of me because I’m not working. I also feel bad because I’m 25 and have always worked even in high school and college. My fiancé keeps saying taking care of the kids is a job itself, but I just don’t know. Is anyone else a stay at home mom???