Let's try to clarify what we are talking about.
If we are talking about the comic books, and the possibility of a resurgence of popularity of Superman as a comic book character, we have never been as far from the target as we are today. There are several factors at play here - including the so-far-slow, but increasingly faster death of American superhero books as a medium (whereas comic books - that includes mangas - are generally quite healthy). It's a shame because I consider comics culturally relevant and personally speaking I will never forgive Marvel or DC for what they have done to the medium and/or the creators. But if the companies do not trust their own product, there isn't much readers can do. In addition, even in the context of the poor IP farm comic books have become, the Superman bar - as far as I am concerned - is quite low. Basically they are milking the character AND the readers with generally unsubstantial stuff, even if from time to time something readable (PKJ?) may appear. The point is not that they are going to cancel Superman comics pretty soon - I am quite sure that in 10 years something may still exist, maybe similar to what Dynamite comics did with pulp characters, the Phantom and Flash Gordon. The point is that if - ad absurdum - tomorrow Superman comics disappeared wholly from solicitations, very few people would realize it and perceive it as a loss.
If we are talking about movies, and the possibility of a Superman cinematic relaunch, well, we are quite far from that too. The presence of several derivative characters in forthcoming movies or series (Supergirl, Val Zod etc; Super-Pets isn't indicative of much, as said before) IMHO is actually more of a problem rather than anything else - provided the Supergirl movie is successful (and provided they make a Supergirl movie), it will inflate the brand and "steal" distinctive Superman elements which will become more difficult to see if and when they actually relaunch the main character. I mean, if they actually made a Supergirl movie isn't it rather likely that the villain would be Brainiac? And again, IF they think there's some money in it they could actually make an "Iron Man 1" Superman movie, but - for the reasons I have explained above - I have serious doubts it may be really successful.
If we are talking about the character as a whole (I am referring his presence in several media at the same time and how culturally relevant it is in its entirety - let's assume that the peak in this field is the Batman era/decade which included Burton's Batman, Moore's TKJ, Miller's DKR and Timm's Batman TAS), well, that's where things become interesting. I don't think that the CW series will actually help in that regard no matter how many people watch it (as I said above, these specific series are very disposable, people watch them and forget them rather quickly, it's not that the CW Supergirl series has left a huge void or has helped that character to become insanely popular). But the mere existence of the CW series is - if nothing else - the proof that here may still be some juice left in the classic Superman.
The point is - and has always been, for at least three decades, that is basically the only REAL, almost unsolvable problem the character has had - the character needs to be renovated/restructured as a whole. That's the point. No matter how much fans or DC or WB refuse to see it - the character should work again in a modern context, he should have really relatable elements - not because he represents HOPE!!1!! or because people will join him in the sun or crap like that - he should be what he hasn't been for decades - a CHARACTER, not a symbol. And that's something many people expected from New52, Earth One, Man of Steel, etc - and all of them, for various reasons, failed.
So that's the reason my bet is on the forthcoming animated series: it is the only, real context where the character and the dynamics with the supporting cast MUST be redesigned to work. If it was just a rehearsal of the Donnerverse, or the DCEU, it wouldn't work. Because of the format. Because of the target audience. Because of the aesthetics, etc. I actually think that people are overlooking how important for the character that series may actually be - we may potentially have another Batman TAS-level milestone here. And if it works and is popular enough it would be of huge help for other versions of the character. Of course, it has to take a lot of effort to actually work AND be influential. I mean, the forthcoming Caped Crusader series has Ed Brubaker together with Bruce Timm and Matt Reeves and Superman would need at least, I don't know, Mark Waid? Greg Pak? But it would be even better if it was someone very creative OUTSIDE the comic field - basically what the animated series would need is someone akin to Bryan Konietzko and Dante DiMartino, who dealt with Superman with care and freedom as if he was a creator-owned character.
So... These are my two cents. As far as what I will personally do, if it is of any importance, I promise that - provided they don't do anything to discourage me - I will watch a couple of episodes of the series. As for the other Super-related products, I am not interested and I don't think that they are really "important", so my attention will be elsewhere. Of course this doesn't mean that someone else can't enjoy them.