scare-babed

adj.

Drunk in a way that looks dangerous from across the room but proves harmless nearby.

Source: Wiktionary