Horner, who has overseen a period of tremendous success at the F1 team, was involved in a personal scandal last year