Hi, Benjamin.
Welcome to SR!
No need to feel low, guilty or stupid - it doesn't help.
Good for you to reach out for help - and SR is a great place which saved sobriety of many people, myself included.
Hangover will pass. And it's completely in your power to make this hangover the last one and never had this humiliating feeling again.
It's absolutely ok to to scared when thinking about never having a drink again - I was totally terrified in early recovery. Don't look too far in the future for now - focus on now, on today, on the next hour, on next 10 minutes. Your goal for know to make it through - even though by the skin of your teeth. It will get better later.
Drink lots of water, get some sleep. Don't beat yourself up - it's not productive. Yesterday is in the past, you can't change it. But you can make a step in right direction now.
Stick to SR - reading and posting here helped me a lot, it was my lifeline. A lot of wisdom and support here .
Best wishes to you. Hold on.