The position of science in society is a discussion worth having.
Excessive optimism toward science has had fairly detrimental results in the past. Often the problem isn't science itself though.
A trap is that you can't actually derive values from science, because it doesn't provide any -- whatever values you extract from science are those you put in yourself through hidden assumptions. That makes it very easy to lean on science to ostensibly support almost any action through some line of reasoning like "Science shows that if we kill the poor, we'll be able to reduce taxes by 90%. Therefore we should get our guns!" Science doesn't care if our taxes are high or low, it doesn't care if we live or die. Even if the premise about taxes is scientifically correct (I don't know), the conclusion isn't based on science alone.
That's a bit of a parallel to the discussion of lockdowns and masks and so on, while science may be able to answer what effects these have, science can't say we ought to do these things. That requires something else to be added, although sadly the discussion has almost entirely been about what the science says about these things, not the relative worth of saving lives versus individual freedom vs GDP, which is the real discussion.