I save Cid on all of my playthroughs because I feel bad about letting him die like that. I think that it makes more sense from a storyline perspective that Cid dies, as I doubt that Celes would find all of her friends and get an airship and just let Cid stay on the Solitary Island by himself. He has no further role or interaction in the story, either.