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.
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.
Then, there's the problem of the input device. Ever enter a movie name for search using the TiVo remote, AFAIK the best currently available? It's a pain. Now, one thing Google TV gets absolutely right is that your phone will be your secondary interaction device for your TV.
The real interesting question here is: will applications on the Google TV set-top-box be able to access the tuner and EPG functions. TiVo has a nice SDK for their boxes for years now, the reason you never heard of it because they don't allow apps to access these features out of fear from content providers. If you can write Android apps running on the STB that can access the video stream, now that would be super, but I don't expect to see this anytime soon.