There is a dance going on and pastors and church leaders need to be on the dance floor along with everyone else. Watching others dance from the sideline is not healthy. You start to get rusty and stiff and critical of the way others dance.
Did the Bible get it wrong? In Galileo’s day they certainly didn’t think so and Galileo was treated harshly for it. But today, even the most serious christian has to admit that on this side of history, knowing what we know about our solar system, those verses are to be understood as expressing the human experience within the limits of the author’s knowledge of the world in his or her day. It’s writing from ones own point of view. That, by the way, is the best any of us can ever do.