He wouldn't be resurrected. In fact I'm not even sure he'd still be corrupted by Brainiac at that point. Basically his powers, to a certain extent, could be tapped into by whomever wields the Soul Reaver, since that's how the sword works. It absorbs/devours the soul of most people it kills (there's sure to be exceptions which is why I say "most" things instead of "all") and its wielder can then tap into some of the powers those people used to have. In this scenario, you'd have a sword theoretically capable of letting you tap into Superman's strength, durability, speed, etc. Now imagine people like Lex Luthor and a plethora of other supervillains catching wind of it and suddenly you have what could be the plot of its own Elseworlds Tale.