Well, he's alive. In some form at least. He has been reborn as the Herald of Oracle, and essentially now just looks like a normal sized version of Oracle, if a little more streamlined and shiny. Will he eventually become Superboy again? Or is this his identity for the foreseeable future and Jon is the Superboy they're rolling with? Hard to tell right now.