It definitely reduces the cognitive load, letting you drive better in my opinion. But there isn’t an idiot-sensor in the car, so like every technology, there will be people who abuse it. The interesting question is whether those same idiots would be safer in a regular car, or if, on balance, the “autopilot+idiot” combination is safer - that seems like an empirical question to me.
Even at the current level, it’s a great advance on a regular car (I have no idea how it compares to other expensive cars with various assistive technologies, I usually buy super cheap cars...). I also think that if fully autonomous driving is technically possible, then Tesla will be the one to do it - they have several hundred thousand drivers giving them training data in all sorts of weird edge cases every day.
It really is worth watching the whole of the recent investor event at Tesla and then deciding what you think of their technology: https://www.youtube.com/watch?v=Ucp0TTmvqOE