Stay & Try to Work it Out, or Leave?

My husband and I have had a pretty rocky marriage the past year, due to job changes, moving, and it really put strain on our marriage. It also caused resentment to form on both sides, to sum it up. Long story short, our biggest issue is him not showing any affection ever and him not being present at home. It feels like we are roommates. Anyways, we had another fight yesterday except it was way more heated than before. I got mad at him in while we were in bed and he was trying to sleep ( I hate that I bring up important stuff during this time but I get so mad I do it anyways… bad habit.) and he completely freaked out on me like he always does, but it was way worse. He threw all of the pillows that were on the bed at me and said “get f****d, I hate you.” Then went into the other room. When he came back he started yelling and I tried to exit the room, he put his hands on my shoulders so I wouldn’t be able to leave. He continued to yell at me and asked if we would even be able to work this out. Called me a crazy, psycho b***h. He then punched the bed out of anger and looked me in the eyes and told me to get out. I told him I wasn’t leaving and that I had no other place to go, that if he wanted me to leave I would leave the next day. We just moved far away from our home state, so we have no friends or family here. He calmed down for a few minutes and then asked if I wanted to be with him and I asked him the same question right back. He said that he has invested way too much into our marriage, that he would have to make this work. Then he said he loves me. He kept trying to get me to come back to bed with him but I chose to sleep on the couch. I am really shook up over this and I am not sure what to do… would any of your SO’s react this way when fighting at bedtime???