Arsh, wow there are so many things wrong with what your husband has said and with his mindset. I'm a little confused by everything because I remember you saying you and your husband would move to another state after the divorce but now it sounds like you'll stay in the house and he'll simply move to another place in the same state / city? And his sister will live with him when he moves?
There is so much wrong with what's happening it's hard to even know where to start commenting. As I understand, you and your husband both work and have similar jobs so it's not "his" house and he can't blame you for any financial pressure he feels because he's doing this to himself! How can he believe his own words? You're equal to him in every way!
Also your husband's sister living with you - so she's around many times in your house not helping you with the kids and she's on your husband's side? This doesn't sound fair at all.
There are times when we all blow up over the house being a mess and we blame our spouse but the way your husband spoke to you in front of your daughters isn't acceptable at all. Even if he felt guilty and was nicer later, your older daughter will remember the outburst, not the nice gestures later.
I know you already know all of this, but it's such a nightmare you're living in. I can't imagine how you're able to work and care for your daughters with this monster around.
Is there any way for you and your daughters to leave temporarily? Like stay with a friend until he leaves on August 1st? Hopefully if it's just a few more weeks until he leaves and you can get through it but packing up and leaving for a few weeks yourself sounds pretty appealing although logistically so difficult with kids.
My sense is if you still hope to save the marriage, the sooner you can be physically away from your husband, the faster his anger will subside and he'll begin to think more rationally.
