That won't happen for decades. It doesn't help that games are increasing in size faster than hard drives can keep up. I won't be surprised if 100GB games are for 9th generation consoles(AAA games only). Also, physical media will have a market too big to ignore. Nobody is going to abandon that market anytime soon.
At best you'll see a PSP Go style console as an optional model.