SAHM advice

Ladies i JUST found out that I am pregnant. I am so excited and it’s always been a dream of mine to be a sahm. My partner immediately told me i could quit my job although in all the excitement I’m not sure how serious he was. My question is do any of you ever not like it? Like not having your own money and being at home because i know you must all love spending time with your children. Just looking for insight from other mamas on the topic before i make any decisions ❤️