Revelation 14's reference to "unmixed wine" gives us a clue that John's sign of the water turned to wine (in John 6) gives some background.
While not a much-read text by most today, the Maccabees scrolls were widely read and revered in the first century by learned Jewish men. The scrolls end with this pithy closing:
2 Maccabees 15 RSV:
38 If it is well told and to the point, that is what I myself desired; if it is poorly done and mediocre, that was the best I could do. 39 For just as it is harmful to drink wine alone, or, again, to drink water alone, while wine mixed with water is sweet and delicious and enhances one’s enjoyment, so also the style of the story delights the ears of those who read the work. And here will be the end.
It appears to be a truism to the author that the ideal or at least healthiest beverage is neither pure water nor pure wine but a mixture of both. Paul seems to be alluding to this truism when addressing Timothy’s ill health from tee-totaling:
[1Ti 5:23 NLT] (23) Don't drink only water. You ought to drink a little wine for the sake of your stomach because you are sick so often.
The wine obviously was fermented or it would not provide the sterilization referenced. In an age before chlorinated filtered water, this was an important technique.
In addition, they would add spices for flavor and sometimes for their stupefying effect, such as in the case of myrrh.
“Mixed wine” is the term used to describe it:
"properly a mixture of wine and water with spices that increase its stimulating properties." - M. G. Easton (1897b)
But the wine Jesus made was a hit with the host and the guests and possibly boosted Church attendance! :) The reason it was so impressive is that it was unmixed wine. It was pure wine with no water added. Why do I surmise this? Because the water turned to wine is actually an allusion to the soon arriving judgment of Jerusalem in the form of the war with Rome, c. 70 AD/CE:
[Jer 13:12-14 NLT] (12) "So tell them, 'This is what the LORD, the God of Israel, says: May all your jars be filled with wine.' And they will reply, 'Of course! Jars are made to be filled with wine!' (13) "Then tell them, 'No, this is what the LORD means: I will fill everyone in this land with drunkenness--from the king sitting on David's throne to the priests and the prophets, right down to the common people of Jerusalem. (14) I will smash them against each other, even parents against children, says the LORD. I will not let my pity or mercy or compassion keep me from destroying them.'"
By filling their jars with water and turning it into wine, Jesus was alluding to Jeremiah’s prophecy that Jerusalem would be mercilessly destroyed!
[Rev 14:8-12 NLT] (8) Then another angel followed him through the sky, shouting, "Babylon is fallen--that great city is fallen--because she made all the nations of the world drink the wine of her passionate immorality." (9) Then a third angel followed them, shouting, "Anyone who worships the beast and his statue or who accepts his mark on the forehead or on the hand (10) must drink the wine of God's anger. It has been poured full strength into God's cup of wrath. And they will be tormented with fire and burning sulfur in the presence of the holy angels and the Lamb. (11) The smoke of their torment will rise forever and ever, and they will have no relief day or night, for they have worshiped the beast and his statue and have accepted the mark of his name." (12) This means that God's holy people must endure persecution patiently, obeying his commands and maintaining their faith in Jesus.
And John alludes to this to says that Jerusalem (“Secret Babylon”) will be the ultimate fulfillment of Jeremiah’s grim prophecy:
[Rev 16:19 NLT] (19) The great city of Babylon split into three sections, and the cities of many nations fell into heaps of rubble. So God remembered all of Babylon's sins, and he made her drink the cup that was filled with the wine of his fierce wrath.
The great tribulation lasted for three and a half years and when the dust had settled, the Sinai covenant age had disappeared:
[Heb 8:13 NET] (13) When he speaks of a new covenant, he makes the first obsolete. Now what is growing obsolete and aging is about to disappear.
So John may have been referring to the years of anguish of those who failed to listen to Jesus' warning to flee Jerusalem when Titus' army appeared and began his siege of Jerusalem:
[Luk 21:20-24 NET] (20) "But when you see Jerusalem surrounded by armies, then know that its desolation has come near. (21) Then those who are in Judea must flee to the mountains. Those who are inside the city must depart. Those who are out in the country must not enter it, (22) because these are days of vengeance, to fulfill all that is written. (23) Woe to those who are pregnant and to those who are nursing their babies in those days! For there will be great distress on the earth [IE: "the land" of Israel] and wrath against this people [IE: the Jews]. (24) They [IE: the Jews] will fall by the edge of the sword and be led away as captives among all nations. Jerusalem will be trampled down by the Gentiles until the times of the Gentiles are fulfilled.
Or, it may have been a more Hellenized view based on the Enochian visions of Tartarus and the prison of angels he describes:
Peter explicitly refers to Tartarus:
[2Pe 2:4-5 KJV] (4) For if God spared not the angels that sinned, but cast [them] down to hell [Gk: "cast them into Tartarus"], and delivered [them] into chains of darkness, to be reserved unto judgment; (5) And spared not the old world, but saved Noah the eighth [person], a preacher of righteousness, bringing in the flood upon the world of the ungodly;
In fact there are many examples of references to Enoch in the NT:
[Enoch Chapter 13]
1 And Enoch went and said: 'Azazel, thou shalt have no peace: a severe sentence has gone forth 2 against thee to put thee in bonds: And thou shalt not have toleration nor request granted to thee, because of the unrighteousness which thou hast taught, and because of all the works of godlessness 3 and unrighteousness and sin which thou hast shown to men.' Then I went and spoke to them all 4 together, and they were all afraid, and fear and trembling seized them. And they besought me to draw up a petition for them that they might find forgiveness, and to read their petition in the presence 5 of the Lord of heaven. For from thenceforward they could not speak (with Him) nor lift up their 6 eyes to heaven for shame of their sins for which they had been condemned. Then I wrote out their petition, and the prayer in regard to their spirits and their deeds individually and in regard to their 7 requests that they should have forgiveness and length. And I went off and sat down at the waters of Dan, in the land of Dan, to the south of the west of Hermon: I read their petition till I fell 8 asleep. And behold a dream came to me, and visions fell down upon me, and I saw visions of chastisement, and a voice came bidding (me) I to tell it to the sons of heaven, and reprimand them. 9 And when I awaked, I came unto them, and they were all sitting gathered together, weeping in 10 'Abelsjail, which is between Lebanon and Seneser, with their faces covered. And I recounted before them all the visions which I had seen in sleep, and I began to speak the words of righteousness, and to reprimand the heavenly Watchers.
And here Jesus does the same:
[1Pe 3:19-20 NLT] (19) So he went and preached to the spirits in prison-- (20) those who disobeyed God long ago when God waited patiently while Noah was building his boat. Only eight people were saved from drowning in that terrible flood.
And there are many other references to Enoch in the NT. I would argue that the scrolls of Enoch are foundational to the NT teachings and description of daemonic activity and events in the NT. IE:
[Mat 25:41 NKJV] (41) "Then He will also say to those on the left hand, 'Depart from Me, you cursed, into the everlasting fire prepared for the devil and his angels:
[Jas 2:19 NKJV] (19) You believe that there is one God. You do well. Even the demons believe--and tremble!
[Luk 16:27-28 NKJV] (27) "Then he said, 'I beg you therefore, father, that you would send him to my father's house, (28) 'for I have five brothers, that he may testify to them, lest they also come to this place of torment.'
[Jde 1:14-15 KJV] (14) And Enoch also, the seventh from Adam, prophesied of these, saying, Behold, the Lord cometh with ten thousands of his saints, (15) To execute judgment upon all, and to convince all that are ungodly among them of all their ungodly deeds which they have ungodly committed, and of all their hard [speeches] which ungodly sinners have spoken against him.
John also seems to allude to the destruction of Edom:
[Isa 34:8-12 NLT] (8) For it is the day of the LORD's revenge, the year when Edom will be paid back for all it did to Israel. (9) The streams of Edom will be filled with burning pitch, and the ground will be covered with fire. (10) This judgment on Edom will never end; the smoke of its burning will rise forever. The land will lie deserted from generation to generation. No one will live there anymore. (11) It will be haunted by the desert owl and the screech owl, the great owl and the raven. For God will measure that land carefully; he will measure it for chaos and destruction. (12) It will be called the Land of Nothing, and all its nobles will soon be gone.
Edom was destroyed a long time ago and the burning has stopped, leading to the conclusion that the prophets, including Isaiah, were given to a great deal of hyperbole.
I find that if the passage in Revelation 14 is taken without context, it speaks of endless torment. Given the context of the Edom passage, Jewish tradition, etc. it is simply prophetic hyperbole, but if taken in the context of the Greco-Roman Enochian tradition, it might well be taken to refer to endless torment in Tartarus. The scriptures defy tidy categorization as they are written in spaghetti code.