How does cocaine make you sober when you're drunk?

It doesn't. It just makes you feel more alert. Your faculties remain impaired, and you are even more likely to do something else stupid. The only thing that can sober you up is time.