I honestly can't say whether it was an everyday event--I don't know of any source that speaks to that. But wine was most definitely alcoholic. I've seen the claim that it was unfermented, but this is really not supportable historically, not something seen until fairly recently and in religious contexts with an anti-alcohol bias.

Keep in mind that before pasteurization, all you have to do for grape juice to become wine is wait a while. And some texts indicate that old wine, just as now, was thought to taste better. Here are a couple sayings from Avot:

Rabbi Yosi bar Judah of Kefar ha-Bavli said: He who learns from the young, what is he like? He is like one who eats unripe grapes and drinks wine fresh from his wine press. But he who learns from the aged, what is he like? He is like one who eats ripe grapes and drinks old wine.

Rabbi Meir used to say: Do not look at the flask but at what is in it; there may be a new flask that is full of old wine and an old flask that does not even have new wine in it.

That's a 2nd century text quoting 1st century people. As I said before, old wine implies alcoholic wine, and the sayings assume that old wine is better.