The way to get that trust and respect back is to choose to be a nondrinker, you can do it . I don't have the statistics at hand but safe to guess that there are billions of people on the planet who don't drink, some that never have.
Making the choice , really just finding yourself in a position to 'have' to make the choice seems daunting , but most of that is the smoke and mirrors of the addiction itself trying to shake your resolve. Time takes time, and it really does 'get better'.
The trust comes back when people see us doing the next right thing , time after time. We only have agency in the immediate present the 'now' , doing right , right now is not impossible , yeah? How about this 'now'?
You don't have to focus on and anticipate whether or not you are going to 'do' some future 'now' correctly, just this one
( and now this one) You can do it, rootin for ya