Walaikum Asalaam,
Welcome to the forum bro. Sorry to hear about your situation and I hope there will be some members here who can give you sincere and helpful advice inshallah.
One of the first things I suggest is not to make promises to Allah that you may not be able to keep. When you make oaths and you break them, you have to make expiation for it. Instead, every time you err, make istighfaar, pray, give in charity, etc. try to follow up your sins with something good that will please Allah inshallah. I believe that when we do good actions it shapes a much better future and we strive to make the better choices because it feels good and we can see it's effect on EVERYTHING around us. We naturally start moving away from the sins that cause us shame and agony and crave to do the things that pleases Allah inshallah.
Secondly, I know that our ultimate judgement is with Allah subhanahu wa ta'ala, but we have to remember that Allah also gave us the blessings of reason and sent us His laws to better our judgement in all circumstances. I don't know your friends and they are irrelevant in this situation. What is relevant though is how you perceive yourself and your own actions; how you use this judgement and reason that Allah has blessed you with to improve or solve your situation. Friends can absolutely have an influence on an individual, but ultimately you're the one who will be face Allah for the actions you chose to do, no one else. So if you know that you have a weakness (ie. saying no), then you shouldn't be around them. If you know you are amongst company that indulges in haram actions, you shouldn't be around them. Your actions should meet your intentions, so if you intend good for yourself you need to work towards perfecting the action as well even if you are making mistakes along the way. I assume that if they were very good friends of yours, they'd understand if you opened up and told them you don't want to drink at all, but if you don't feel comfortable doing that then just start distancing yourself and seeing them less often until you don't rely on their company. Not only does not drinking benefit you, but it will benefit them as well because there is nothing good that comes from the consumption of alcohol anyways. You also never know when the last day or even hour of your life will be. Sometimes we feel like death is far away but it is much closer than we think. You don't want to return to Allah intoxicated. It would break your family's heart so so much more than it otherwise would have.
You're going to have to learn to navigate social pressures in this society and unfortunately it can be a bit difficult especially as a revert or someone who is newly coming into Islam (even born and raised Muslims), but when you put Allah and yourself first, it becomes easy because the opinion of others will not matter anymore. Every soul is valuable, don't diminish your quality for the sake of social expectations. You'll find billions of drinkers, but how wonderful and prideful is it to feel like your reliance is in Allah subhanahu wa ta'ala? You don't need a drink to ease your stress, feel joy, or socialize. You have all the tools in yourself to overcome every single obstacle that comes your way with Allah's help and will inshallah. Whatever you leave for the sake of Allah, He will
always replace it with something better!
In conclusion:
1. Distance yourself from your friends (you will find better ones).
2. Don't drink anymore because it affects the most important aspects of your life and no one should care about that more than you,
3. Keep turning to Allah by doing good actions.
For your last question, the best support you can honestly get is to either be around
good company who have a greater positive influence on you in terms of iman whether it is online like this forum, other reverts and muslims, your family, and/or to be by yourself where you can focus more of your time and energy making a closer connection with Allah. You can always find support from Imams inshallah, I don't want to discourage you from that, but you'll have a better chance of finding a response you can resonate with when you expand your support system. Never forget your biggest supporter is Allah inshallah so also make sincere du'a for guidance.
You absolutely need to leave behind this lifestyle that you're still stuck in. You are moving forward, keep going forward; either the people go with you or they stay behind, but there's never a need for you to regress. You'll see what or who matters in the end. I commend you for seeking advice, and I hope you find your way bro
