I never liked the Williams theme much, sounds too much like marching music or like parade music to me, that's what I think of when I hear it, a parade. And to me it doesn't capture the spirit of what Superman truly is, maybe for the Donner films but I find those flawed as well so there it is. Williams himself admitted that the film had a certain amount of camp to it so the score had to reflect that and not be too serious. Well, I find that degrading for the character and it wouldn't in any way fit with what MOS is going for.
So I am VERY happy the Williams theme is finally put to rest. But then I am also not a huge fanatic of big memorable themes being a necessity for these films. I much more value that a score fits the tone/mood of the story and melds with that and the visuals of the film so that its all a whole experience not that there is a theme which rises above everything and sticks out.
I don't necessarily need a theme I can hum. For example, the MOS comic-con trailer. The JTTL theme used fit PERFECTLY and had a great effect together with the tone and visuals and IMO if you'd put the JW theme over it it would sound much worse. Yet, I couldn't remember or hum the JTTL theme for months. Doesn't matter when I watch it though because it works perfectly in context.
And knowing Zimmer, he'll deliver exactly what I want and perfectly too. But hey if he can also create a theme that is memorable and yet fits all those criteria, more power to him. I do have a soft spots for Elfman's Batman theme though. IMO it was much more fitting with the character of Batman than JW theme to Superman AND it fit the movies perfectly as well. Win-Win.