I definately think the NCO's should be punished but nothing more than a loss of rank, transfer and a harsh verbal warning. The rest of the others probably could just use a harsh verbal warning and clean up & kitchen duty for a while.
Oh, is that all? How sweet of you, destroying a hard-earned career for having a beer with the troops. Good grief.