If one was to believe the prophecy (which I wouldn't, btw. I have a Catholic friend and he thinks it's bullshit), then yes, "The End" is considered Judgement Day/Armageddon/Apocalypse/Whatever. So, that would be after Pope Benedict XVI dies. I'm still not clear on whether it means the world will cease to exist when Benedict dies, or when the Pope after him dies. Meh.