In Paul's day no one knew about bacteria nor about the antiseptic effect of alcohol but they did know that water without wine added to it was unsafe to drink. Timothy was not treating his water with wine and as a result he was frequently getting sick from the germs so Paul "prescribed" treating his water with wine:
KJV 1Ti_5:23 Drink no longer water, but use a little wine for thy
stomach's sake and thine often infirmities.
This in turn was "prescribed" in his scriptures in 2 Maccabees:
Brenton 2Ma 15:37 Thus went it with Nicanor: and from that time forth
the Hebrews had the city in their power. And here will I make an end.
2Ma 15:38 And if I have done well, and as is fitting the story, it is
that which I desired: but if slenderly and meanly, it is that which I
could attain unto. 2Ma 15:39 For as it is hurtful to drink wine or
water alone; and as wine mingled with water is pleasant, and
delighteth the taste: even so speech finely framed delighteth the ears
of them that read the story. And here shall be an end.
So like advocates of medical marijuana we know that Paul certainly saw consumption of wine for health reasons to be legitimate. But the OT goes further:
Psa 104:14 He causeth the grass to grow for the cattle, and herb for
the service of man: that he may bring forth food out of the earth;
Psa 104:15 And wine that maketh glad the heart of man, and oil to
make his face to shine, and bread which strengtheneth man's heart.
So wine has a cheering effect and "herb" is likewise "for the service of man".
But here Paul is cautioning about being drunk by overdoing it and compromising one's safety and usefulness. That is the concern that Paul raises. He is like the anxious mother of Proverbs:
Pro 31:1 The words of king Lemuel, the prophecy that his mother
taught him. Pro 31:2 What, my son? and what, the son of my womb? and
what, the son of my vows? Pro 31:3 Give not thy strength unto women,
nor thy ways to that which destroyeth kings. Pro 31:4 It is not for
kings, O Lemuel, it is not for kings to drink wine; nor for princes
strong drink: Pro 31:5 Lest they drink, and forget the law, and
pervert the judgment of any of the afflicted. Pro 31:6 Give strong
drink unto him that is ready to perish, and wine unto those that be of
heavy hearts. Pro 31:7 Let him drink, and forget his poverty, and
remember his misery no more. Pro 31:8 Open thy mouth for the dumb in
the cause of all such as are appointed to destruction. Pro 31:9 Open
thy mouth, judge righteously, and plead the cause of the poor and
needy.
The usage of the word νήφω itself maps well to our English word, "sober":
1 a : sparing in the use of food and drink : abstemious b : not
addicted to intoxicating drink c : not drunk 2 : marked by sedate or
gravely or earnestly thoughtful character or demeanor 3 : unhurried,
calm 4 : marked by temperance, moderation, or seriousness a sober
candlelight vigil 5 : subdued in tone or color 6 : showing no
excessive or extreme qualities of fancy, emotion, or prejudice
https://www.merriam-webster.com/dictionary/sober
Albert Barnes has this to say on the verse in question:
Therefore let us no sleep, as do others - As the wicked world does;
compare notes, Mat_25:5.
But let us watch - That is, for the coming of
the Lord. Let us regard it as an event which is certainly to occur,
and which may occur at any moment; notes, Mat_25:13.
And be sober -
The word here used (νήφω nēphō) is rendered sober in 1Th_5:6,
1Th_5:8; 1Pe_1:13; 1Pe_5:8; and watch in 2Ti_4:5, and 1Pe_4:7. It does
not elsewhere occur in the New Testament. It properly means, to be
temperate or abstinent, especially in respect to wine. Joseph. Jewish
Wars, 5. 5, 7; Xenophon, Cyr. 7. 5, 20; and then it is used in a more
general sense, as meaning to be sober-minded, watchful, circumspect.
In this passage there is an allusion to the fact that persons not only
sleep in the night, but that they are frequently drunken in the night
also. The idea is, that the Lord Jesus, when he comes, will find the
wicked sunk not only in carnal security, but in sinful indulgences,
and that those who are Christians ought not only to be awake and to
watch as in the day-time, but to be temperate. They ought to be like
persons engaged in the sober, honest, and appropriate employments of
the day, and not like those who waste their days in sleep, and their
nights in revelry. A man who expects soon to see the Son of God coming
to judgment, ought to be a sober man. No one would wish to be summoned
from a scene of dissipation to his bar. And who would wish to be
called there from the ball-room; from the theater; from the scene of
brilliant worldly amusemet? The most frivolous votary of the world;
the most accomplished and flattered and joyous patron of the
ball-room; the most richly-dressed and admired daughter of vanity,
would tremble at the thought of being summoned from those brilliant
halls, where pleasure is now found, to the judgment bar. They would
wish to have at least a little time that they might prepare for so
solemn a scene. But if so, as this event may at any moment occur, why
should they not be habitually sober-minded? Why should they not aim to
be always in that state of mind which they know would be appropriate
to meet him? Especially should Christians live with such vigilance and
soberness as to be always prepared to meet the Son of God. What
Christian can think it appropriate for him to go up to meet his
Saviour from the theater, the ballroom, or the brilliant worldly
party? A Christian ought always so to live that the coming of the Son
of God in the clouds of heaven would not excite the least alarm.
KJV unless otherwise noted