Tom Brady signed a 10-year, $375 million deal with FOX Sports in 2024 after retiring from the NFL and the quarterback's role has come under the spotlight in recent weeks