Although I do not encourage drinking among Christians, the wording in John Chap 2 makes it clear that the wine, was indeed, alcoholic. We make ourselves look like fools, when we make a relationship with Christ be about whether or not to drink beer. To show what I mean with the verse meaning, lets look at the Governors response to the wine. I will highlight a couple of important Greek words:
Joh 2:10 And he said to him, Every man at the beginning sets forth good wine, and when men have drunk well, then that which is worse. You have kept the good wine until now.
Lets look at these words:
Good wine:kalos
Thayer Definition:
1) beautiful, handsome, excellent, eminent, choice, surpassing, precious, useful, suitable, commendable, admirable
So what did they consider "Good" wine? According to Jesus, the Old, fermented wine was the more to be desired:
Luk 5:39 And no one after drinking old wine desires new, for he says, 'The old is good.'
Drunk well So what, according to the Governor of the Feast, is the result of drinking "good" wine? Why, it is the meaning of this word, used in connection with Good wine:
methuō
meth-oo'-o
From another form of G3178; to drink to intoxication, that is, get drunk
So, the Governor of the feast just said that the wine Jesus provided was the "good" kind that is capable of making you drunk. Jesus, in a separate passage, ALSO called the old, fermented wine the "good" wine.
Jesus undoubtedly provided alcoholic wine at the wedding. This does not mean he encouraged intoxication, anymore than him providing good food would be encouraging gluttony. Sin is not dictated by a thing, but by our use and reaction to that thing.