As someone who works in science-based academia...I beseech and implore you with all the earnest at my command to turn away from this portion of society and cease to treat it as your fountain of happiness lol. Get married, have kids, join a community at church, talk to your neighbors, volunteer for community service, read books at an old persons home, do meals on wheels, grow vegetables in your backyard and sell them at farmers markets etc do something, anything that forges meaningful connections to others in your proximity, but don't rely on our growing understanding and ability to manipulate/work with creation as a religious source of happiness and sanity lol.
Science is a tool to understand, manipulate, work with and exploit creation to our benefit, and I contribute to it as best as I can. Science is wonderful, but it is not to be worshiped, nor are those of us within its apparatus - we're human, fallible and vulnerable to all the vices of man, from envy, to pride, greed and wrath.
That little speech aside, the answer is never. Science is cataloguing and understanding the natural processes and behaviours of the natural world. Even if we nuke ourselves back into the stone age and 99.99% of humans on earth perish in the calamity, that still leaves ~780,000 of us across the world learning which rocks are best to strike together and at what angle so that fire can be sparked, meat can be cooked, spears can be carbonized and torches can be used to keep the mutant wolves at bay while we throw our javelins at them. We survived the ice age equipped with little more than animal skins and pointy sticks - we're pretty good at long-term comebacks.
The other direction is continuing on our current path, where we'll probably end up uploading our minds via neuralink into computers and cloning/growing new bodies we can download ourselves into for essential immortality. Even in such a fantastical outcome, there'll always be more to learn and more to discover. There is a literal galaxy out there of things to discover and learn, and we, out here on our spiral-arm of the Milky Way are billions of years behind and 25,000-28,000 light years away from the centre of that galaxy. The more you understand, the more you realise how very little we know.