No, it won't support Yahoo or Napster. It supports DRM-free WMA.
Rockbox is an entire replacement firmware, it's not just new music support. It's very different from the built in software, so I strongly suggest reading the manual and perhaps the Why Rockbox link on the front page.