Of course it does. But there's 2 sides to it.
Becoming a supervisor or boss of any sorts brings on new responsibilities and new problems. You no longer have to worry about just your work, you're now responsible for others'.
Being the cool guy at work is almost impossible when you're incharge because when sh*t goes down, ultimately, its on you.
Whenever there's a problem, the first question someone asks is "who's responsible for this"? Right?