I don't know @cryptopie This does show very poor judgement and someone could have been seriously injured or killed.
Carrying a loaded weapon is literally a life and death situation, so being drunk and doing backflips with a loaded gun is good cause for being discharged of duty.
I know it is a tough judgement, and I am glad it won't me doing the firing but this is very serious.