AI is likely to pay off eventually, but investors are getting sick of all the hand-wringing over near-term returns, analysts say.