CNN as well as the other sites including YouTube require Flash.
Open System Preferences > Flash Player then select the Advanced tab.
Click Delete all under Browsing Data and Settings.
Back to Safari. Empty the cache by pressing Command + Option + E on your keyboard.
Quit and relaunch Safari. Try a video on CNN.