My dog is doing the same thing!! WE just got a puppy and he has been..well extra special. I would be a horrible SAHM indeed. My mom was one, I am not knocking it by no means- just I couldn't imagine being Martha Stewart 24/7.
I always have grand illusions that I would love to SAH - then I go on maternity leave and I cannot wait to go back! I swear, I could work 2 full time jobs and be less stressed then I am when I am at home for more then a week.
Our dog goes crazy when it's raining, too. He has insisted on sleeping in our room the past 2 weeks or so, as it's been miserable outside all but maybe 2 days