We know two things that are certain at this point in the manga, regarding attacks on Konoha:

1) Sasuke wants to destroy Konoha
2) Pein is at Konoha, and wants to find Naruto and presumubly destroy Konoha

Pein is actualy at Konoha or near to it at the moment. I think its safe to say that Pein will not succeed because if he does then Sasuke wont be able to destroy Konoha. Which is fairly obvious.

I think that Sasuke is a more important character than Pein, and therefore he will be the one to attempt to destroy Konoha. So its safe to assume that Pein will die trying.