Yes, he did die in the end. It has been stated clearly throughout the game that Black Mages can only live a limited amount of time. Vivi was a prototype and therefore lasted longer than the other Black Mages. Vivi's ending dialogue, and the fact that he was the only main character who didn't make an appearance at the end of the game suggests it.