Roy Kramer, the visionary behind the SEC Championship, has died at age 96, leaving a lasting legacy in college sports