Ed Yardeni said Big Tech leadership is fading as AI shifts from creation to adoption, with future market gains likely coming from the broader S&P 500 rather than the Magnificent 7.