may impair your erectile function, and alcohol
is well known to relieve anxiety (and self-consciousness, shyness
etc), at least temporarily.
I can't think of any other reason. In "macbeth" shakespeare noted that drink "provokes the desire, but it takes away the performance." so the opposite of your discovery is more often the case.