Basically, a Weepy drunk is a person who gets on their soap box and cries about their woes and troubles when drunk.
Alice: What's wrong with you kid?
Nick: -is drunk- My life is spiraling downwards. It sucks the world is not a pleasant place to be. My wife left me...(etc)
Alice: God you're such a weepy drunk