Belief in scripture as literal truth in light of the science that derives from our God-given brains is neither rational nor, in my opinion, God’s intent.
Ultimately, one must discern the source of the truth used in their assumptions. If God intends to reveal any facet of knowledge to us in any area where we might be mistaken, one has to discern how He would do that. Appealing to science as the final arbiter of truth, places faith in the Creation rather than the Creator.
The miracles recorded in Scripture aren't allegorical. Changing large pots of water into wine involves something considerably more than simple phase transformations. Wine is organic and the carbon atoms in the wine had to come from something which water doesn't have.
Raising from the dead, then walking through walls after resurrection isn't easily explained by science.
Fundamentally, the Christian way of life is a supernatural walk with God through faith alone in Christ alone. Science is a useful tool of empiricism and rationalism to explain many natural phenomenon and to calculate anticipated natural events, but fails miserably when attempting to describe, explain, or even document the supernatural through faith in Christ.
This doesn’t mean one abandons science, but it does indicate there is something beyond science which science is wholly inadequate to grasp.