It is not Heliocentrism that leads to a loss of faith, but rather trying to use exegetical principles other than those taught by the Church. When people try to use the Bible to determine matters of physical science, it is inevitable that there be apparent conflicts between Scripture and science, as well as within Scripture itself, because that is not its intended meaning. When people accept the Church teaching that Scripture does not intend to speak of physical science, there will never be such conflicts. There will never even be a temptation to reject Scripture for the reason you suggest. The Church, in her wisdom, long ago solved this problem. This exegetical principle goes back to St. Basil and St. Augustine and, starting with Leo XIII, appears in the magisterial writing of several popes.
Concerns about people rejecting Scripture because of science is normally a Protestant problem. Due to their heresy, they try to interpret Scripture for themselves without the wisdom of the Church to guide them. Of course, they will run into problems. But there is no reason for Catholics to see this as an issue.
If you have science based reasons to believe the earth is flat, go ahead. But appealing to Scripture for support is a rejection of Church teaching on Scriptural exegesis and of the Church's authority as sole interpreter of Scripture. It is a serious error.
Sorry Jane, but you seem to have missed the point of my post. Regardless of what you think people should do, the reality is that people do in fact reject The Bible, because they believe it can't be God's Word, if it isn't accurate in regards to Science as well as History, Archeology, Psychology, ect.
Furthermore, I don't know what catechism you are reading from, but the ones I have read, are consistent with The Bible. Sure, there are times when a passage from The Bible could be interpreted to mean one of two things, but when taken in context and in its entirety, most of those are resolved. For the few that aren't crystal clear, The Church may perhaps have used its power to interpret, but never does it contradict The Bible.