It actually works surprisingly well, but I've not traded in my SLR. Being able to do something similar with a second lens -- or even using Project Tango sensors -- to avoid the post-exposure motion would make it more useful, but I suspect still not as versatile (and even with my SLR, the difference between my relatively cheap lenses and borrowing someone's more expensive lenses, on the same body, is quite obvious).
This means objects and figures that aren't faces might not be tuned too well.
https://www.amazon.com/Nikon-Wireless-Mobile-Adapter-Digital...
Many of the reviews say it is not very good, but I have not tried it personally.
Then there is Geo tagging.
https://www.amazon.com/Nikon-GP-1A-Unit-Cameras-27034/dp/B00...
Again, reviews are pretty poor.
Like I said, I love my DSLR, but the phone workflow is just so much easier/nicer.
With a phone, you just tap the share button on the picture you just took, tap the icon for whatever you want to share it to and you're done.
I surely don't and do exactly the same workflow with my phones as I do with my cameras.
Other priorities might be ok to have their pictures known to the world.
I am moving all my photos from the last few decades into Photos/iCloud which will then appear on my phone.
Edit: Also, you definitely don't need to fire up Lightroom to share photos from your DSLR; I think practically any DSLR can shoot JPG. Many DSLRs can also share photos to phones via wifi or Bluetooth these days. Mine didn't come with such a feature, but Nikon sells a $20-30 adapter that adds that capability.