I don't know what to do

I (m36 ) can't take it anymore. The newborn phase is hell. My almost two moths old doesn't stop screaming whatever we do. I haven't slept more than 30 hours in total the last 45 days. I ’ve been experiencing severe dizziness and vertigo, likely related to sleep deprivation from caring for her. Last night, I had to visit the ER because the dizziness became so intense that I couldn’t walk or lie down without feeling overwhelmed. Everything was spinning like a very bad hangover and then some. It was frightening, as I initially thought I might be having a stroke.
We don't have any help and our home is a one bedroom apartment so I don't have a place to just sleep quietly as much my wife wants to help me because I go to work and she is a stayed home mom. Does it get better? I regret every decision that led me here so far.

Update: Thank you all for your suggestions, advices and very thoughtful comments. I am going to stay for a few days on my mother in law, and she will come home to help my wife. So it's a small win, I guess. I hope to feel better soon. Stay strong everybody.