I've been captaining my 8-ball team for probably 9 years or so (currently not the actual captain as since the Covid I can't be there every week, so another is technically the captain currently, tho I'm still playing when possible).
One player on my team has been with me for those 9 years. We are also on a separate 9-ball team, almost as long a period of time. She is the captain of that team. Neither team has any other players on the same team as long as us, tho we have one player on the 9-ball team that joined a year after us, still with us.
You asked another poster "if they got drunk". You seem to have a preoccupation with this subject. As I and many others have tried to point out to you, League pool is designed to be played in drinking establishments, and many of the people playing League will indeed drink. If you have that strong an aversion to be around people who are drinking, you should try and come up with another way to satisfy your pool playing interest.