Husband says he’s unhappy, I feel lost

I’m posting him because I know it’s an honest and I don’t want judgment if someone happens to know me and I don’t make the decision they think I should. We have been married six years this year at Christmas and together six years already. We have a 4 year old son, 10000% planned, an 8 mo old daughter, kinda planned but we didn’t think it would happen so fast, we conceived first cycle. And a couple weeks ago I found out I’m pregnant again, because I was on a medication that had the potential to make my birth control ineffective but I wasn’t warned of that. So while we were coming to the decision we only wanted our two this pregnancy happens. Obviously we were both shocked but we decided to have this baby, I’ll get my tubes tied because I’m confident I don’t want any more. But my husband, who has always struggled with depression and anxiety seems to be having bad days more often the past few weeks. Today he hit me with “I’m unhappy, I’m going to stay with my dad for 2 weeks to figure this out” aka I’m unhappy with my bad career choices, I put all the responsibilities on my wife to find me schools, and set everything up even though she owns a nail shop and works full time as a medical biller and is a great mom…. I asked him what’s he so unhappy about and his answer was just unhappy in general. It’s so frustrating because I have stood by his side when I know I should’ve walked away, but when I love someone, I love them with my all, even to my detriment sometimes. I truly thought they were past what happened in 2020/2021. We’ve been investing we’ve been making more money. I see potentially being able to buy a homesoon. I don’t understand What more I could do to make him happy. I know it’s not my responsibility to make him happy but why 2 weeks? Why wouldn’t we do couples counseling or if it really is just unhappiness within himself why not go inpatient for psych help or see a therapist at a minimum.

At this point I feel broken and empty and exhausted. How long does one try before saying okay, you want space you got it? I am fully confident there are other men who would love me for me and my kids. Why am I trying so hard to make this work and should I keep trying?