Rocky star's cause of death revealed ahead of Super Bowl honor