The Metropolitan Opera’s new Siegfried, part of its ambitious Ring cycle, exposes the greatness—and the limitations—of Wagner and his admirers