The leadership path was once the ultimate career milestone—but is it still worth it? A look at why so many managers are questioning the role and what the future of leadership could look like.