Not to get too specific but the fear will go away as others have said. I have seen and even personally experienced some pretty scary things and no matter what the fear part fades and we forget- humans are pretty much programmed to forget as a defense mechanism so you can eventually get back to normal life. Unfortunately in this case it would be nice in a way if the fear could stick around but it wont.
It seems horrible now but you will slowly pay the bills/lawyer/fines/court costs, you will settle into the classes or whatever they give you and you'd be surprised but you will probably be laughing about the DUI part in a few months. Wanting to get sober for yourself is going to be the focus.