Let's see, I guess the pill could cure the hangover and prevent disease. It would also have to prevent you from fighting, yelling, falling down, passing out on a bench, etc. while drunk. You'd have to make alcohol much cheaper and then revoke all dui laws. So, in all, I don't see it happening...
If youre talking about a pill that would cure alcoholism, I don't think so. The idea of just drinking one or two seems useless to me, even with a magical pill.
Someone told me one time that alcohol is really just a symptom of the problem