Although "Blame It on the Alcohol" is all over the place, there's legitimately good stuff in there worth exploring, and it kind of comes together in the end (using Glee standards). Whether the writers explore them later is another question, and from their track record, probably half the plots will be forgotten about.
The big thing in the episode is alcohol, the all-powerful substance people can't stay away from. It sparks several storylines--Rachel and Blaine kissing, which leads to inspiration for Rachel's song and confirmation that Blaine's gay, and a drunk dial from Will to Sue intended for Emma--which all resolve quickly and with little conflict The actual plot, singing a song for the school so people don't drink, is hardly important, though the impromptu heaving did leave the school wary of alcohol.
Score: 8.2/10