This perspective is true to some extent, but it’s counter-productive to think of science as being wrong.
You should think of science as the “least wrong” set of beliefs we have at any point in time. It will never be perfectly right, and every day it’s less and less wrong. The reason it’s so reliable is because it embraces (and doesn’t dismiss) this uncertainty.
Terribly often, science grinds to a dead halt on some range of subject matter until certain scientists retire or die. It is easy to list remarkably recent cases where they did finally die and work could proceed, and many others where they have not died yet and the field is still stuck fast.
Science will always be incomplete. It has nothing to say yet about most possible questions. What it does pronounce upon should be reliably correct, but that is often not true, traceably to those individuals who maintain falsehoods. Sometimes the falsehoods become doctrine and hang on even after the offenders have obliged by dying.
I don't think it's counter productive at all. There was a period of time, when the appendix was (absurdly) considered vestigial, that surgeons would remove the appendix as a side quest if they happened to have the area opened for some other purpose.
That was a terrible idea, but one that was supported by science at the time. There are practical reasons to be skeptical about scientific assumptions.
Science becomes less wrong faster if we allow history to remind us that a lot of what we believe will likely turn out to be wrong.
You should think of science as the “least wrong” set of beliefs we have at any point in time. It will never be perfectly right, and every day it’s less and less wrong. The reason it’s so reliable is because it embraces (and doesn’t dismiss) this uncertainty.