To a certain extent. There's a lot of software that just isn't allowed on the App Store.
Until Apple flat out disallows outside software from running on OS X, and doesn't allow that to be overridden (which I doubt will happen, at least for several more OS versions), sites like MacUpdate will be around.