The real problem is to access the video stream. Currently this is viewed to be illegal (see the lawsuit in 2001 that pretty much sank ReplayTV, http://www.eff.org/cases/newmark-v-turner).
The vast majority of Comcast's channels and content can't be accessed without a cable card or cable box.
An interesting thing can happen if Google does partner with a cable provider to also add cable TV functionality to the box. I heard they've already partnered with Time-Warner for trials. That would be another TiVo-like system, but, of course, much more open. I see little chance of them persuading the cable guys to let their apps fiddle with the content, though. But who knows, it's Google.
There's almost no way this makes it into a terrestrial cable box outside of a few trial markets. Or with a few small cable providers. I say this as someone who spent 4 years working for a large cable co building software that runs on cable boxes.
There's a bunch of reasons but here's two.
1. The large cable co's aren't generally going to deploy software controlled by a 3rd party. Microsoft has spent years banging their head against the wall that is the large telco with little success.
2. Cable already has a mature cable box focused software stack standard called tru2way which is already getting more traction then Android likely ever will in cable STB space.
The cable space is not normal and they don't make what appear to be rational sw decisions to the internet crowd.
Dish is an outlier and doing everything they can to compete but I wounldn't even count on them going into wide deployment with this.
This will live on CE devices, not cable and satellite STBs.
Only of the TV and this would only work with "Over the air" tv. In the US most of us receive our TV and guide via our cable or satellite box and tune via that mechanism. Google TV and competing products have no easy way of accessing that data (the guide data and tuning).
There's some hacky ways of doing it but nothing really integrated.