There was actually two kinds: fermented and unfermented. You cannot get drunk on unfermented wine and we have many scriptures pointing to that. Noah for example. David, etc
There were no refrigerators back then. So unfermented became fermented in about five minutes, maybe.
There are countries, for example those bordering the Mediterranean Sea, which have a sacramental world-view, which says that an infinite God comes to meet finite man using the things of creation: water, oil, bread, wine, the touch of a hand. People of those countries believe that all creation is good. They tend to be connected with the earth, with hard work, with simple pleasures. They appreciate sex as a gift of God not only for procreation but for physical and emotional joy. In those countries, wine is just another gift of the Creator to be accepted in moderation and with thanksgiving.
Then there are other countries, for example those to the north of Europe, which have almost a gnostic world-view, which says that all flesh and matter is weak and sinful, and only intellectual things are pure and godly. They hold that God meets man only in the mental realm, and approach the bible as a set of doctrines which need to be properly decoded. They say man is saved by knowledge and assent to key doctrines. People in those countries tend to believe that creation is fallen. They tend to be connected to business, to the power of investment capital, and they hold a man's financial success as a sign of his election. They accept sex as a necessary evil for the procreation of more tithe-paying foot soldiers for God. In those countries, wine is evil, based on their dictum that "if it feels good don't do it."