I'm also a cycling fan and agree with much of this.
My gut feeling to be honest is that he's going in as a favour to Ratcliffe and Brailsford's demands will be so exacting that he'll quickly realise what an absolute disaster zone the club is and just walk out and tell them to fuck off after 6-9 months.
Objectively it would make sense for them to maybe hire him as an occasional consultant or something to do workshops and training on leadership, but having him on staff actually managing the sporting side seems totally mental to me.