quite the opposite on the burn out part… if you are curious (this in my experience is in the top-5 traits of exceptional SWEs) you will instinctively want to learn everything there is to know about what you are building. and do it at your own pace, to use a cliche, this isn’t a sprint, it is a marathon.
the leadership also does not have to be competent, you actually want slight incompetency because competent leaders would not allow project to heavily rely on one or handful of people.