Apocalypto is the Spanish word for Apocalypse--which in the original Greek means "I reveal" as in St John the Apostle who wrote the Book of Revelation...and all that entails.
Mel has reasons for naming it after the divine book of the Holy Bible.
http://en.wikipedia.org/wiki/Book_of_Revelation
What has that got to do with a perfectly good insult?