You've had some great advice. A budget that you can stick to is the most important thing to consider. I don't have any stats for you, but I do have personal experience.
I was a SAHM for a year after my daughter was born (our 2nd). I had been a Realtor for two years before she was born to spend more time with my son. That worked really well before the bubble popped. :) (Before that I was a career professional in a pharmaceutical company gone almost 11 hours a day.) After a year at home, we found it wasn't financially feasible for me to be at home anymore. We were losing ground, and dipping into savings almost every month - even living on a tight budget. I'm now working 30 or so hours a week second shift, but will need to change that before next August, when my son will start kindergarten. We've talked about me staying home again (now that the other house is sold), but it's scary to give up that extra income - especially because we have next to no child care expenses. My husband is EXTREMELY money concious, and with our budget as is, we can't afford it right now. However, we know what bills we would need to pay off in order to be able to afford it (our van will be gone in a couple months, an old student loan is right behind it, etc.). But, that would get us into our regular budget without leaving room for vacations, Christmas, or unexpected expenses (like the furnace going, car repairs, unexpected medical expenses) and we'd have to cut back on eating out (we eat out once a week). And this is all on a very comfortable salary (I don't know exactly what my husband makes, but it is over $70,000) with a really low mortgage (less than $600 including escrow) and no car payments. We already keep costs down by ad-matching at Wal-Mart, garage sales for kids' clothes, and I get almost all my clothes at Goodwill or Salvation Army. We do give away more than 10% of our income and save about the same, but we feel those things are non-negotiable.
All that being said, if you feel strongly about it, it's possible. You just might need to make a LOT of changes (including changing your husband's view of it). It sounds like you would have to completely change your lifestyle. Be prepared! It's doubtful you'd be able to afford an expensive mortgage and two sizable lease payments. You might start by preparing a workable budget to show your husband, work on how to lower expenses (don't make the mistake of using credit!), and start saving money while you are still working. Try to live on only your huband's salary for a few months while putting your salary in savings. Track where every penny goes, so you have a realistic budget (and don't forget about additional expenses like heating bills going up, Christmas, birthdays, travel, clothes, etc.). If you have miscellaneous debt like credit cards, student loans, furniture payments, etc. pay them off before trying to stay home!!! The biggest stress you'll have being home is making money stretch. Having debt hanging over your head will drive you crazy!
When I was home, my kids were very young and clingy. I found that I needed time away about once a week or every other week just to be alone. I'd usually lock myself in the bathroom in the evening and take a bath to relax and be alone, too. I loved the flexibility, being there for my kids, and being able to volunteer to help in other areas. But, working a few hours a week has been great. It gets me out of the house and interacting with adults. If given the choice, I'd choose not to work, but I'm not sure I'm willing to give up the little luxuries like sister weekend getaways and nice date nights with my husband that we couldn't afford if I was staying home. We also want to give our kids the best education we can (they are both very bright for their ages), and if I'm not working they'd be in a less than stellar public school system. We haven't given up the idea, but while I'm working we're targeting as much debt as we can. Once the minor debt is paid off, we're planning to at least double our mortgage payments to get that paid down quickly. That way we can always refinance down the road if it becomes absolutely necessary (we only owe like $58,000 - stretching that over 30 year would really cut down our mortgage payment). But be careful to not get upside down on your mortgage. I'm a big advocate of keeping the term on a mortgage as short as possible.
Sorry this is so long. O.k. Here's my summary.
*Know what lifestyle changes you (and your husband) will be willing to make to make it work (downsize house, sell cars, stop eating out, etc.) Keep in mind long-term goals like retirement, college for your kids, etc.
*Track every penny in and out
*Create a workable budget with room for unexpected expenses
*Start paying off debt
*Start building up savings
*Set a long-term target date to quit your job (maybe a month before your daughter starts kindergarten).
*Start living the new budget - without fudging!
*Have a back-up plan if the budget doesn't work (get a part time job, get a different job, find something to do from home, etc.)
*If everything falls into place, and your husband agrees, quit your job and enjoy being able to stay home!
I wish you the best. Just make sure you go into it with eyes wide open. :)