Someone who is so ugly, that they literally look like they have had too much alcohol. Someone like this will have a constant look that when people see him/her, they will want to throw up.
Hey, have you seen Mary today?
Yeah, she's become Shit-faced Sober.
Huh, what a shame.