It was actually really good for the time and lightyears ahead of whatever Flash was doing.
But people rather used all kinds of hacks to get Flash working on Linux and OSX rather than use Moonlight.
A big chunk of their strategy at the time was around how to completely own the web. I celebrated every time their attempts failed.
After a while people got tired of doing updates.