Coffee doesn’t really help one to sober up; though it does help fight sleepiness.

to become less drunk

More rarely, sober can refer to one who is rational rather than under the influence of extreme emotion. Also more rarely, it can reference that which is practical rather than fanciful — such as "a more sober plan."