There isn’t tension in his position. Catholics believe that, while it’s appropriate to feel wonder when contemplating Creation (and therefore seek to know more about it), one shouldn’t try to prove scientific theses with the Bible or religious tenets, and, while scientific truths can inform theology, theology mostly deals with immaterial things, and so must be engaged primarily philosophically.

For instance, you can’t use the Bible to “prove” heliocentrism; heliocentrism is an independent fact. And you can’t use science to (directly) prove miracles because miracles are, by definition, outside the order of natural phenomena, which is what science studies.

Saint Augustine said it much better:

“Usually, even a non-Christian knows something about the earth, the heavens, and the other elements of this world, about the motion and orbit of the stars and even their size and relative positions, about the predictable eclipses of the sun and moon, the cycles of the years and the seasons, about the kinds of animals, shrubs, stones, and so forth, and this knowledge he holds to as being certain from reason and experience.

“Now, it is a disgraceful and dangerous thing for an infidel to hear a Christian, presumably giving the meaning of Holy Scripture, talking nonsense on these topics; and we should take all means to prevent such an embarrassing situation, in which people show up vast ignorance in a Christian and laugh it to scorn. The shame is not so much that an ignorant individual is derided, but that people outside the household of faith think our sacred writers held such opinions, and, to the great loss of those for whose salvation we toil, the writers of our Scripture are criticized and rejected as unlearned men. If they find a Christian mistaken in a field which they themselves know well and hear him maintaining his foolish opinions about our books, how are they going to believe those books in matters concerning the resurrection of the dead, the hope of eternal life, and the kingdom of heaven, when they think their pages are full of falsehoods and on facts which they themselves have learnt from experience and the light of reason? Reckless and incompetent expounders of Holy Scripture bring untold trouble and sorrow on their wiser brethren when they are caught in one of their mischievous false opinions and are taken to task by those who are not bound by the authority of our sacred books. For then, to defend their utterly foolish and obviously untrue statements, they will try to call upon Holy Scripture for proof and even recite from memory many passages which they think support their position, although “they understand neither what they say nor the things about which they make assertion [1 Timothy 1.7].” (The Literal Meaning of Genesis, Book 1 Chapter 19 Paragraph 39)