If I was manager the players would definitely want me sacked. And not just because I'd be crap.
Managers will have a certain style, and when they leave there's almost always stories about how they were terrible (and to a degree I'd be more worried if there weren't) and how the new one is so much better. Rinse and repeat.
If I'm a football manager, sometimes I'm going to tell you as a player things that you don't want to hear, and sometimes I'm going to make you do things that you don't want to do. If I wasn't there would be literally no point to me, as you'd have everything covered. The big danger is that once the tail find out that they can wag the dog. They will.