Something slightly changes, but in time things will reach a new normal that everyone's comfortable with, you can't change the past but by apologising and being more organised in the future it'll be ok, and you'll reach a sort of inner peace about it that's usually matched by your friends :)

I had the same thing happen to me, luckily I kept most of the friends due to them being understanding, but I heavily regulate my drinking to only drinks that work from me so I never really get more than tipsy.