husband called me a great mother but a terrible housewife

Let me start by saying my husband is a good guy most of the time. He recently ran out of weed and anytime he runs out of weed or there is no alcohol in the house he turns into an ASSHOLE. He has a medical card for weed and he went and bought some last week and it's gone already so I told him he had to wait until the next pay check to get more because the money could be spent on better things. This morning he woke up and was in a horrible mood because he had no weed. He had been gone for the last 3 days with his friends so I asked him to help me with our children. He starts screaming at me that he wants to go to the beach so he can drink and when I told him no he starts yelling about how we need to clean the house (even though it's clean..). I told him that the house is clean and I would really appreciate a break today I since I haven't had one Since he left and he told me I was SOL because I'm a SAHM and that's my job I don't get breaks. He then told me in a great mother but a shitty housewife, which I know is crap because people always compliment me on how clean my house is when they come over he was just trying to create a fight. He told me that he shouldn't have to lift a finger when he comes home and he can't handle the mess (he's literally talking about 4 toys on the ground when he came home last week because we have a two year old). He's constantly telling me how much better his friends wives are than me and tells me I need to go to the gym constantly. I'm just so deflated. I got in my car tonight and left and I'm now at my brothers house until I decide what to do next. I won't have my kids around a man who can't stand to be around his family unless he's high. Thoughts?