I also do not think that the end--if there be one--would come from a triumph of atheism--but the consensus that God did indeed exist but mankind choosing to reject Him regardless. It's just one bunny's opinion but it seems to accord with the calamities that have befallen those who openly rejected God throughout the balance of scripture.
An interesting idea, but... I have difficulty imagining why someone who is given incontrovertible proof that the supreme being exists would reject it. Then again, I have always imagined that if I were ever to have a meeting with the supreme being that it would go extremely badly because I would probably handle it like Captain Kirk did at the end of Star Trek V...
http://fr.youtube.com/watch?v=WYW_lPlekiQ&feature=related
Most people tend to handle meeting God up close and personal in the same general way:
Exodus 3:6 Then he said, "I am the God of your father, the God of Abraham, the God of Isaac and the God of Jacob." At this, Moses hid his face, because he was afraid to look at God.
Judges 13:20-22 As the flame blazed up from the altar toward heaven, the angel of the LORD ascended in the flame. Seeing this, Manoah and his wife fell with their faces to the ground. When the angel of the LORD did not show himself again to Manoah and his wife, Manoah realized that it was the angel of the LORD.
"We are doomed to die!" he said to his wife. "We have seen God!"
Ezekiel 1:26-28 Above the expanse over their heads was what looked like a throne of sapphire, and high above on the throne was a figure like that of a man. I saw that from what appeared to be his waist up he looked like glowing metal, as if full of fire, and that from there down he looked like fire; and brilliant light surrounded him. Like the appearance of a rainbow in the clouds on a rainy day, so was the radiance around him.
This was the appearance of the likeness of the glory of the LORD. When I saw it, I fell facedown, and I heard the voice of one speaking.
Matthew 17:6-7 When the disciples heard this, they fell facedown to the ground, terrified. But Jesus came and touched them. "Get up," he said. "Don't be afraid."
Luke 5:8 When Simon Peter saw this, he fell at Jesus' knees and said, "Go away from me, Lord; I am a sinful man!"
Revelation 1:17 When I saw him, I fell at his feet as though dead. Then he placed his right hand on me and said: "Do not be afraid. I am the First and the Last.