The question, though, is: Did it?
I know a lot of people who had tuned out of the game before the Switch ad aired and only came back late in the fourth quarter to witness Atlanta's complete implosion/New England's meteoric comeback. The ads up to the point of the Switch reveal were lackluster with the ones generating the most "buzz" being the Mr. Clean ad and the AirBNB diversity ad. Even the Budweiser ad was muted by the fact that it was out there way ahead of time.
The amount of awareness that was spread is likely extremely limited. And those who did see the ad and become interested, how do you think they'll feel come March 3rd when they realize they aren't getting a Switch because Nintendo is shipping a pathetic amount which have all been sold to die hard fans (and some scalpers) through preorders?
I do agree with you that what counts going forward is their campaign throughout the rest of the year. The original Wii had a very good, very concise ad campaign that helped sell the system. Switch needs the same. But considering so far Nintendo hasn't exactly been consistent on what the Switch's primary role will be (handheld? console? motion control? traditional gaming?) with their own fanbase, I can't say I'm optimistic they'll have a strong marketing campaign.
It's already getting a lot of views on Youtube before the event and getting some more after the event, some websites also featured the Super Bowl ads (like the Time linked earlier), a lot of people are tuned in to the event, etc. So it did its job. Whether the ad makes people interested to the system is a different discussion altogether, since we'll never know until a specific study is conducted, like a nationwide survey or something.
And of course the availability is also a different story. Even if it's not available day 1 due to very high demand, not everybody interested in a system are day 1 buyers anyway. The major thing here is to maintain the interest of potential buyers. And that starts with the continued advertisement, and followed by a strong word of mouth from early adopters.