Is it possible for someone to feel energized by having responsibility, like being a manager at work?

Yes — very much so. For some people, responsibility actually creates energy instead of draining it.

There are a few psychological mechanisms behind this:

Purpose activates motivation
When someone knows that others depend on them, the brain often switches into a more focused, purposeful mode. Responsibility creates meaning, and meaning is energizing.