In the throes of the widespread criticism of the lenient suspension in the Ray Rice case, Goodell has stated "I didn't get it right." He has absolute power as judge and jury in determining the penalties for off the field misconduct. In future situations he could be at risk again for not getting it right.
Losing in a Super Bowl does not make an NFL quarterback any less of a legend. Just like being in and winning a Super Bowl surely does not automatically grant legendary status to a quarterback.