The appointment of one of the most world's best-known sports celebrities underlines the Kingdom's highly ambitious plans