My husband and i got in a huge fight tonight

So my husband got home from being away for the past week today. He immediately starts talking about how next year he wants to make extra Money so he has more to spend on his hobby which he has a ton of. I've always been supportive of all his hobbies. Always. Sure there are times where i ask him not to go. But more times then not i tell him to go enjoy. Anyways he's been away all week and starts talking to be excited about this thought he has. Me being the hormonal person i am starts thinking about how we have so many expenses that the money should go towards. Buying a house, paying off debt, a child and one on the way, and i totally burst his bubble. He went from being so excited to so pissed off. In my mind i heard "money going towards hobbies not family" where that wasn't the case. He said he wants to make more so he can take a small portion. He said i burst his bubble. I should have just shut my mouth let him be excited and then approached it another time about my concern but ofcourse that's not what i did. My husband tends to hold on to things in his head and be angry for what feels like forever. I'm so emotional because all i want to do is be with him, cuddle, be sexy, etc. i haven't seen him all week. And all he wants me to do is leave him alone. I think he's blowing it out of proportion but that's what he does. He didn't want me to touch him when we went to bed. He wanted me far away. Then we were both up tossing and turning at 5 am. And i asked him if he's ok. He's like just got a lot on my mind. Great. Than he got up and went and slept on the couch. Sure our marriage isn't perfect. There's been times i don't give a lot of affection. And that's on me. I'm tired all the time and i need to stop making excuses. But at this point right now I'm worried about my marriage. Nothing i am saying is making the situation better. I feel like he's out there on the couch with his mind going about how I'm not super affectionate and how i get angry so easily. I called his friend to ask advice before bed and he said to leave him alone. Well that's what I'm doing and I'm afraid it's causing a bigger wedge. I just am venting and need advice. My husband isn't an asshole. But right now he's being overly sensitive to a situation that shouldn't have blown up this big. I don't know what to do.