Despite popular belief, optimism about the artificial intelligence (AI) revolution isn't universal on Wall Street.