From a cricketing perspective it's bad as we don't stand much of a chance in Australia without him.
From Stokes' perspective, his international career may be over, he's potentially at risk of landing up in jail.
Drink does strange things to people, including clouding their judgement. It was silly to get into that situation. However, we don't know the full picture yet, but it wasn't Stokes who had the glass bottle.