The Supreme Court ruling against Aereo was a very "pro-consumer thing" and a "terrific victory" for content providers, CBS CEO Leslie Moonves said.