Indeed. It's not about wanting them to fail, it's saying that just because you were a great player doesn't mean you'll be any good as a manger.
Lots of top managers weren't top class players, and that arguably helps them because it means they have to understand the game better if they want to...