How do I bow out gracefully?

As I have posted before, regarding my disgraceful actions at a recent halloween party and earning the disgust and disapointment from my friends and crush ( I was drunk and made alot of insults towards my crush and her guy friend, in front of her mother too!). We had planned for months to go to a concert together next week, me, my crush, her mother, brother and sister and friends. But the smoke hasnt cleared cleared and I've been given the silent treatment. I had made up my mind and decided that by not going to join them for the concert was the best I can do and move on...

Now I have apologized to them many times as I've stated in my last post. But I am so overwhelmed with disgust for my self and having me go along with them to this concert would make the whole mood become awkward. I know they havnt gotten over what happened, and they dont want to talk about it. I felt like I lost some of my best friends and lost out on a chance at having a wonderful girlfriend over my jealousy and distasteful actions at that party that night.

So how do I bow out gracefully and tell them how much i care for them, and how if possible do i ever regain their trust in me.