They won't for people who need all of the functionality of an SLR or dedicated GPS. But how many of the people buying such things actually need all of the functionality? Quite often, they don't. They buy more than they need to indicate status, or because they fear having an inadequate device.
Tablets provide an alternate form of status at the moment. And the fear of inadequacy is mitigated by their popularity: If everyone is buying one, how bad can it be?
Single-purpose cameras and GPS devices are well on their way to marginalization as extremely niche devices. I think that will be true of almost everything a tablet can replace.
I think if phones started coming with a better flash, it be very hard to justify bothering with a separate point-and-shoot camera. Although, to be fair, most point-and-shoots have a pretty crappy flash as well.
Another generation or two to sort out the always-on/background bugs of current iOS GPS apps and the battery life bit, and tablets will take over - fast processors, big screens, easily available hardware already present to develop on (sound, internet access, etc). Why not?
So for all intents and purposes, I think it'll replace cameras and GPSes for the mainstream consumer, and you'd only use dedicated hardware in specialized cases.