The reason why science is successful is because, when the evidence says so, scientists are collectively prepared to admit they were wrong. This is why we aren't stuck with the geocentric model of the Universe, or phlogiston or caloric or the luminiferous aether.
It only becomes problematic the minute science stops changing its stand in response to evidence.
I agree that all scientific findings are tentative. The problem is the authority that science tends to have.
It doesn't matter in such things as the Big Bang or sub atomic models. But if it is to do with health, diet, medication and such things, it does matter if science....in spite of all the years of clinical trials and so on....is wrong. And so often too! Every other day we see some reversal or withdrawal of earlier findings/conclusions.
It only shows that all the studies, trials and research are not as conclusive or fool proof as people like to think. We seem to be incapable of seeing the long term effects of most things (ecological disasters and climate change being major examples).
Industry and its part in sponsoring or directing research is also a matter of concern.