Will an outstanding law student, passed for everything, decline in points after an alcohol intoxication (a night in the hospital). What can be done?

Stop drinking. It sounds like this student has a serious issue with alcoholism. Treatment for alcoholism requires a multidisciplinary approach that also includes counselling for the student.