You're assuming Carr is just middle tier. Moore thinks he's better than that.
Even so, you don't have to have a "historic or borderline historic" defense to win with a Super Bowl with a middle tier QB. You just have to have a solid offense, defense, special teams and really good coaching.