Storywise, because he was a Black Mage, and they all died before too long.

From a design perspective, because the death of a character usually makes he or she more memorable, not that this particular character needed it to be awesome.

It's not said outright (I think) that Vivi dies, but it's strongly implied, and it's generally believed that the narrative during the ending is his words.