I have not tried CNN, but I've got several video podcasts from revision3.com streaming onto my N800, using the "Video Center" application in the Nokia repository.

You could easily add in new podcasts and get your CNN fix that way.

I've configured my installation of Video Center to use an external player (mplayer), as it handles more formats than the built-in Media Player application does.