As far as I'm aware, the only thing is lacks is any sort of aperture control. That's because it's fixed at, from memory, F2.2.
Does that mean it's not the same as a DSLR? Yes, that's exactly what it means.
Does it mean it's much better than anything else you can get in a phone (and most things you get in point-and-shoot)? Yes, it does.
But the killer app here is the 41mp. Each photo sensor is awful - look at 1:1 zoom and you'll see so much noise it'll give you headaches. But that's not the point. The point is that you can scale that down to 21mp and there's be much less noise. Put it through noise ninja and there'll be less again. Bring it down to 5mp and it'll, in some circumstances - common circumstances - be up there with the Micro 4/3rds cameras.
I'll be buying one, and I'll be buying the camera grip with the extended battery built in. When I'm out as a tourist or a proud dad, I'll carry them both. From day-to-day, I'll just carry the phone and be ready to take far better photos than almost everyone else.