One of the most infamous voices in sports today is officially retiring after more than 40 years on the job