A lot of things to consider...
Would he be the kind of SAHD to do housework, make dinner, take care of things during the week so you can have time to relax together on the weekends/nights?
For me, if he wasn't willing to do the things I'd expect of myself as a housewife (I've never been one, but my mom was), I would see myself getting resentful. However, if he was home doing those things so I didn't have to all the time? That would be awesome.
I've been a single mom since my son was three, so I have to do it all on my own anyway. I wouldn't do it all on my own with another grown adult in the house. But if it's a partnership and both take on roles that balance things, great.