In the short term, science may not be all that reliable, but keep in mind that we know that this particular data is unreliable because replication attempts have rendered it highly suspect.
In some areas, science is self correcting over a much longer time horizon than others. For fundamental physics, a comparably easy to correct misapprehension would be unlikely to persist for so long (in a modern day context.) In medicine, it might last much longer (because there are so many hypotheses to evaluate relative to the available research funds and manpower, and there's often inadequate communication between scientists who research stuff and doctors who implement it.) Psychology isn't the absolute bottom of the heap in terms of speed of correction, but it's well down there.
Science is not particularly reliable.
And yet, we have remarkable technology, and can do medical marvels.
My tentative theory is that there's a lot of knowledge that's less formal than science in engineering, manufacturing, and the practice of medicine which makes it possible to get work done, and some fairly effective methods of filtering information that comes from science.