I think it's a demotion, really. I think he'd have less say there than he does here. I think in terms of personnel, here he has near absolute control. Plus, he's from Texas. His family is here. He went to college here. You're not from Texas, so I wouldn't expect you to understand that. But Texas people tend to stay in Texas.
The only "upside" is that he'd be responsible for negotiating contracts with players. That may be something he's into, but he's never had any sort of training in that regard, so I couldn't know. Personally, that would be the worst part of the job to me, which is why I use quotes for "upside."