As science advances, there seems to be less and less for God to do. It's a big universe, of course, so He, She, or It, could be profitably employed in many places. But what has clearly been happening is that evolving before our eyes has been a God of the Gaps; that is, whatever it is we cannot explain lately is attributed to God. And then after a while, we explain it, and so that's no longer God's realm.
One of the saddest lessons of history is this: If we've been bamboozled long enough, we tend to reject any evidence of the bamboozle. We're no longer interested in finding out the truth. The bamboozle has captured us. It is simply too painful to acknowledge -- even to ourselves -- that we've been so credulous. (So the old bamboozles tendto persist as the new bamboozles rise.)
The significance of our lives and our fragile planet is then determined only by our own wisdom and courage. We are the custodians of life's meaning. We long for a Parent to care for us, to forgive us our errors, to save us from our childish mistakes. But knowledge is preferable to ignorance. Better by far to embrace the hard truth than a reassuring fable. If we crave some cosmic purpose, then let us find ourselves a worthy goal.