It is the abuse of alcohol and the problems it causes that leads to this thinking. I've heard a Pentecostal preacher say that though the Bible says "a little wine is good for the stomach", if you never indulge, you'll never overindulge.
It does make some sense.
The fault of the Pharisees was that they had attempted to become righteous, but kept falling into sin. Hence, they moved to block all opportunities for accidentally sinning. Hence, the commandment "Thou shall not boil a calf in its mother's milk," became "You are not permitted to eat dairy and meat at the same meal." Thus, under the Pharisees, the Jews became heavily oppressed.
For this reason, the New Testament explicitly commands that we are not to add to the law, or lay religious burdens apon people. Telling people that they may not drink wine, when Jesus himself provided wine, is not only not sensible, it is downright sinful.
The Catholic Church tells people to avoid the near occasions of sin, but allows people to decide for themselves what such near occasions are. For the soul struggling against alcoholism, he may not enter a pub. Yet, for others, they may drink away. As Paul instructs us, extraordinary fasts and abstinences should not be imposed on others, nor should they be forbidden. (Before you even think it, joining the priesthood is a voluntary discipline.)