I suspect that long-term outcomes vary with the offense and whether criminal activity is involved.
Justine Sacco was an exec who lost her job over a dumb/offensive social media post.
She seems to have overcome the fallout.
Getting drunk and attacking restaurant staff, then continuing an assault outside might be harder to overlook, especially if employers decide the incident reflects deeper issues. But with so many people acting out, the availability of p.r. tools to cover up the past on Internet searches, and news media propensity to whitewash their sites and wipe out criminal histories, it’s doubtful that this person will be unemployed for long.