In early times, people had a very limited concept of the earth itself, nevermind the universe. It required less of God to have created what was known back then. But when you start with the premise that all that exists is God's creation, then as our understanding of what exists expands, then our idea of God's greatness must expand along with it.
Today, we embrace a universe with dimensions that stagger the mind and were impossible to be understood by earliest civilization. Some even postulate the existence of other universes. We also are learning more about the details of our own planet. We are learning ever more down to even the subatomic level. Our knowledge as a civilization is expanding both outward and inward. We should never fear scientific discovery, for all truth is God's truth. Rather, our appreciation for God's greatness should only continue to grow.