Never, point and shoot yes, but it will never replace SLR.
If you take Apple computers as an example and this was in the news just this last week. There are a lot of professionals able to do their work these days on MacBook Pro's, high end iMac's and iPad Pro's, but then there are still a small percentage who needs the power and capabilities of a Mac Pro. So yes maybe more and more casual users and hobbyests will be able to ditch their SLR's in future because phone cameras will suit there needs, but there will always be a group of professionals who needs high end stand-alone cameras.