"While sci-fi offers artificial intelligences that rival our own, the fiction bears little resemblance to real world AI"
It would be more appropriate to say that so-called real-world 'AI' bears little resemblance to intelligence. Calling "specialized software that helps fly planes and run factory production lines" AI is a tacit admission of failure, at least for now.
I do not mean to imply that the Turing test is the only or best test of AI, but any such test means little unless it requires that actual intelligence is displayed, just as any test of an airplane should require actual flight.
Keep Up with TechRepublic