I think the noobmaps should be resurrected in a way as its own campaign. Having it as a mod might've been more practical pre-2.0, but I think keeping it as such is kinda moot, considering most newbies aren't going to know where to look for it, much less how to install and get it to run.
The video might be helpful, but ultimately an in-game tutorial is probably what will help most new players get the basic game elements down.