Alphabet's CEO presented a vision of AI that was at once optimistic about the technology’s possibilities and sober-minded about some of its present limitations.