Correct. It can (will be able to) talk to npm, pip, RubyGems, cpan, the full gamut of package providers. Connecting to things like Windows Update, Microsoft Dev Center, etc. are also possible to implement.
What a complete wasted effort it has become. It could have been so much more. Plus it scared Steam so much that we now have Steam OS and have over 1200 Linux games now available.
I used Ninite for years and recommend it to non-techy friends. As a dev, I prefer Chocolatey since it offers a lot more dev-focused packages, meta-packages, can be scripted, works with BoxStarter, etc.
https://ninite.com/
I can't wait for the new package manager in Windows 10, though.