Does the hidden leaf village ever get destroyed?

Yes. Pain comes and kills almost everyone lotta people die, kakashi does to.. but Naruto has a talk with the real pain at the end of their fight, and pain see's naruto's vision and decideds to undo all he did and resurrect all the people he killed ... this ends up killing him.