After my second son was born I was stressing about going back to work but knew we couldn't survive on my H's salary alone. He also wasn't happy at work so I modivated him to find a better job he would enjoy. He had some contacts that wanted to hire him so that helped. I went back to work for 3 months and then quit once he started the new job. It's not for everyone and I have the urge to punch people when they ask me what I do all day, non SAHM moms. But I love it most days, sometimes we just need a break and it's important to make time for yourself. That's one of the hardest things but it's wonderful to be able to stay at home in my opinion.
That being said, getting to be with my son all day every day is the most tiring, wonderful and fulfilling experience. Sure, I'm cooped up in the house way more than i would like to be, and all the cooking and like 98% of the cleaning generally falls on me but I'd rather that than trusting someone else to look after my son (family issues etc, etc). Fair warning though, there are good days and bad days. Some days he naps like a hibernating bear and I can cook and clean while he sleeps and I feel like super mom. Other days i don't even get to brush my hair and I feel like an ogre.
If it's possible, I probably won't get another job until he is in school, and ideally I'd work part time during his school hours and would be off on time to pick him up.
Money has been tight and we've made sacrifices along the way, but wouldn't have it any other way.
Also have to say I do get stir crazy sometimes. SAH can be very isolating. I miss the adult interaction a lot. And once my 3 are all in school, I will be working at least part time.
As long as your SO is on board 100% I say go for it.
Some mom's are better mom's going to work. It's a lot to think about what you think you will like. I didn't want to do daycare if I went back to work because dd wouldn't get as much attention and a nanny was way too expensive and I wanted to be there for milestones. Literally have to look at everything and see what works best for your family!