People who reject the Bible for not being accurate in regards to Science are ignoring Church teaching on Scripture. Often it is because they are looking for an excuse to avoid obeying God.
What catechism are you reading from that says Catholics should believe the earth is flat?
Scripture. Vatican I,Canons and Decrees, Chapter III: Of Faith, says:
... all those things are to be believed with divine and Catholic faith which are contained in the Word of God,, written or handed down, and which the Church, either by a solemn judgment or by her ordinary teaching (magisterium),proposes for belief as having been divinely revealed. ... ... although faith is above reason, there can never be any real discrepancy between faith and reason; since the same God Who reveals mysteries and infuses faith has bestowed the light of reason on the human mind, and God cannot deny Himself, nor can truth ever contradict truth. The false appearance of such a contradiction is mainly due, either to the dogmas of faith not having been understood and expounded according to the mind of the Church, or to the inventions of opinion having been taken for the verdicts of reason. We define, therefore, that every assertion contrary to a truth of enlightened faith is utterly false. Further, the Church, which together with the apostolic office of teaching, has received a charge to guard the deposit of faith, derives from God the right and the duty of proscribing false science, lest any should be deceived by philosophy and vain deceit (can.ii) Therefore all faithful Christians are not only forbidden to defend as legitimate conclusions of science such opinions as are known to be contrary to the doctrines of faith, especially if they have been condemned by the Church, but are altogether bound to account them as errors which put on the fallacious appearance of truth. (D1797-8)
Galileo would have us believe that there is an absolute separation in Holy Scripture between matters of faith and morals and matters pertaining to the physical sciences. That such is not at all the case, Pope Benedict XV assures us in Spiritus Paraclitus (Sept. 15, 1920):
... by these precepts and limits [set by the Fathers of the Church] the opinion of the more recent critics is not restrained, who, after introducing a distinction between the primary or religious element of Scripture, and the secondary or profane, wish, indeed, that inspiration itself pertain to all the ideas, rather even to the individual words of the Bible, but that its effects and especially immunity from error and absolute truth be contracted and narrowed to the primary or religious element. For their belief is that that only which concerns religion is intended and is taught by God in the Scriptures; but that the rest, which pertains to the profane disciplines and serves revealed doctrine as a kind of external cloak of divine truth, is only permitted and is left to the feebleness of the writer. It is not surprising then, if in physical, historical, and other similar affairs a great many things occur in the Bible, which cannot at all be reconciled with the progress of the fine arts of this age. There are those who contend that these fabrications of opinions are not in opposition to the prescriptions of our predecessor [Leo XIII] since he declared that the sacred writer in matters of nature speaks according to external appearance, surely fallacious. But how rashly, how falsely this is affirmed, is plainly evident from the very words of the Pontiff.