I could see using the CloudUp hosted solution in addition to or as an alternative to the default media library, however, I don't think it can ever replace it. Many people won't want to host their files elsewhere and many large corporations who may be looking at WP will have policies prohibiting it. For your average blogger or small site, though, it may be an easier way to work with media and allow some strain of loading resources all from the same server.