If not the biggest, certainly close, at least as far as college sports scandals. OJ also would be up there. Highly popular athlete, TV commentator, pitchman, movie personality, being accused and tried for two murders, acquitted in criminal court but found liable in civil court.
In terms of the high and mighty falling off very tall pedestals, you might also consider Mickey Mantle and Willie Mays being banned from baseball, Pete Rose, the Black Sox Scandal. Wikipedia has an interesting
list of sports scandals; a good reminder of some that were in the headlines back in the day. Wikipedia fails to include a huge corruption scandal involving Italian soccer players, teams and referees a number of years ago. Big for the Italians but not sure there was one Paterno type of individual who took a huge tumble.
Virtually all of the above involved questionable conduct involving the game; Paterno was fired and his legacy damaged (destroyed?) for actively covering up the activities of a child rapist on his staff, likely adding to the depth of his downfall.
In politics, probably not much to rival Richard Nixon being forced from office.