@RottenGrapeJuice, your post should be separated into tow questions 1) how long does microbial spoilage take? and 2) how long do changes in the chemical soup take to taste bad?
First, microbial spoilage can be totally eliminated by good sanitation and maintaining fences that prevent growth as alcohol and pH and low oxygen. Industrially we can be more sloppy and use only one fence as just filter at 0.45 micron or only pasteurize. . . . ie your microbial life can be measured in centuries/ how long till an event where the bottle busts.
Next oxygen is the enemy of alcohol. Wine can oxidize if it microbiologically sterile, if it is frozen, if it is contaminated with metals, and if it is treated with metabisulphite or SO
2. Again oxygen is the enemy since it is one source of peroxide which promotes reactions where the soup is changed from reduced high energy molecules to more oxidized molecules. (We can measure the redox potential to put a number on the ratio of high energy molecules) Some companies have the technology where they press grapes under CO
2 and flush hoses and tanks with nitrogen and package under a vacuum so they can build decades of shelf life without adding metabisulphite. I (and likely you) don’t have most of these technologies (I can vacuum package) so I would put the shelf life in weeks or number of times when the carboy was opened times the volume of oxygen which is introduced.
If you smell a defect it is too late! If the defect is below threshold level the redox potential tells me it is there and I could predict rate of change till an average consumer would smell it.
Your original post is looking for a number, ,,, YUP you should get months if the oxygen and copper and iron are excluded. The best number is months
at a few times opening the carboy if you have minimal/ no oxidative headspace (use inert gas or 1cm ullage or vacuum) or
one time opening the carboy if you have ullage at the shoulder of the carboy and fill it with air.
If you want to look more at the science I have posted what some of the experts say in the thread “a course”