CNN enlisted celebrities and musicians to bring relevance to the struggling network for a heavily promoted special on Sunday night that turned into its second-least watched Sunday primetime lineup from 8-11 p.m. since 1997.