First, I have to say that I don’t have experience dealing with a loved one who is a heavy drinker. However, what was done was done. Alcohol or not, the betrayal happened. Just keep in mind that as long as that person continues to use alcohol heavily, this could happen again and again.
Next, I would say the regret they feel is worth further examination. Do they regret drinking alcohol so much? Do they regret getting caught? Do they regret hurting you? You have to be the judge of whether they are worth keeping in your life based on which ones you think it is.
Finally, I’m sorry you find yourself in need of a site like this, but I’m glad you found your way here. There are so many people here who can give you words of comfort and encouragement, so keep the questions coming as long as you need to.