Well done for seeing the problem and admitting it.
Every time the guilt, shame or self-hatred hits, remind yourself that you are going to need to be kind to yourself to give yourself the best chance of getting better. Those negative thoughts about yourself are unhelpful for recovery (because addicts can be prone to thinking ‘I’m just a shit person and I’ll never be able to sort this out/I don’t deserve kindness or a better life).
You do deserve a better life, as do your children and partner.
As many others have said, these feelings of self-loathing will only take you so far. Once the hangover and the shame has faded, thoughts begin to creep in that actually maybe you will be able to just have one on special occasions. Or holidays. Or weekends. Or weekends plus one weeknight, two weeknights… it spirals so easily back to where it was before and the self-hatred and self-sabotage kicks back in: ‘I knew I wouldn’t able to do it. I’m not strong/brave/good enough’.
Could you start thinking about some little routine changes that might take you sufficiently out of your daily routine to feel that life is already getting better? Get some treats in- are you a foodie? Get some lovely quality edible treats to enjoy for the next few days- maybe some ‘unhealthy’ treats but also some very nourishing, wholesome foods. Some good soups or ingredients for a lovely stew. Plan some other things that you know you’ll enjoy- baths? Movies? Long walks in the countryside? All of these things could contribute to a feeling that you are really nourishing yourself- because you deserve that. You deserve to feel physically and mentally healthy. Do you exercise? I work in fitness and have met a fair few (clean/sober) addicts in my classes. Many of them have or have had mental illnesses (besides their addictions) MANY are ND. They find exercise is great for their self-esteem and MH. They can find headspace when they’re moving their bodies. And of course, getting physically fit helps the body to heal from the excesses of alcohol or substance misuse.
Good luck OP. You can do this. 💐