sober up

become sober after excessive alcohol consumption; "Keep him in bed until he sobers up"

become more realistic; "After thinking about the potential consequences of his plan, he sobered up"