As a SAHM, I am always going crazy, but I stay home because I can afford to and I feel that my kids need me, not a perfect setting, but me. Little kids need their moms as much as possible. It is a proven fact. You need breaks and you need adult time. You can figure out how to do that without working, like work out at the gym and put your kids in the gym daycare for an hour a day. Or go out with your girlfriends once a week, or get together more often with your girlfriends and their kids for some mom chat while the kids play together.
Moms who love staying at home love to sacrifice and learn to love it because we know it is worth it and not all about us but about the kids. The time goes by so fast before they are all school age and you won't see them for over 6 hours a day. Can you wait until they are older. Time seems to go by so slowly when they are tiny and it is extremely taxing and difficult, but then those years are gone and you can't have them back again, ever.
I think it is about the struggle to be a great at home mom that builds your character, and the sacrifice that goes along with it. You can't take anything with you when you die, and at your deathbed, the thing you will care about most is how your kids turned out.
I think it is great that your husband wants you to be a stay at home mom and wants to provide for you. He is a stud! What a great guy that is willing to pay for everything you guys need and wants you home to nurture the kids. It shows how much he loves his kids and his family.