No one is saying the steering wheel will disappear, but new McKinsey research found a greater acceptance of autonomous-driving technologies.