Yeah, I understand it's not that easy to find a job. It's not like you can just "get another job" these days with no effort. This whole thing was not only embarrassing, but it also put you in a tight spot. There's no way around it, this was a bad experience.
We all grieve in different ways and if you stay in bed all day there's nothing wrong with that. A lot of folks would do the same. You don't need to get back on the horse right away - it will be alright, though yeah it's tough to see that now.
One tiny thing to remember is the role alcohol played in this. You were sober for 2 months, and enjoying work. You broke your sobriety, went out and got wasted and the next day you were fired. Coincidence? Maybe. But perhaps there was more to your drunken evening than you know? And if not - maybe you should just take this as a sign. Maybe this is a good time to focus on sobriety? Are you 100% clean from all prescription drugs, and alcohol? Do you have a way to work on this?