Approximately 1 year ago I canceled my TV subscription, the extra $50/month and the freedom of not having TV control my life are both fantastic! In this short amount of time, downloading has basically disappeared from my life.
During the first few months of being cable-free I would purchase items on iTunes, possibly (wink-wink) download movies via torrents, and get some loaners from my friends. Now I basically stream* everything from Netflix, TV Channel Sites, JustinTv, YouTube Movies, and the National Film Board. There still isn't a lot of live sports streamed, but sports networks such as TSN and CBC are starting to live stream some of their games (all highlights are viewable on their site). It has been approximately 5 months since I downloaded anything, the need is just not there anymore.
Along with downloading, the traditional TV model will die and will be replaced by a web-based model in some shape or form. People won't have to be home at 10:30 to catch the latest episode of Fringe, they won't be limited to watching it solely on their TV, and they won't be in zombie mode as they are watching it. It may take a while, Apple TV and Google TV may be the Neanderthals of this new model, but it will happen, and we will all love it!
*Note: I live in Canada and we don't have streaming services (legally) such as Hulu and Amazon Video