I don't read this as Superman crying for himself, but for Kara. He's figured out what's coming, but it's seeing his beloved younger cousin for the last time, knowing what's going to happen to her, that really gets to him.

And even if he was? A Superman who doesn't want to die but faces the end anyway is more hopeful than one who never felt sadness.