In my experience, becoming a go-to person gets your boss promoted. This was the case in 100% of my roles, until the very last one, when I refused to become this person....and my boss was fired.

Sadly through that process my role was orphaned, so I was also let go in the round of 2,000+ layoffs that shortly followed.