The ESPN app requires a cable subscription (with verification through your account with your provider). There are no Cartoon Network or Fox Sports apps.
The Apple TV is not a TV in the sense that it receives broadcast signals, it's a box that connects to the TV and allows you to stream content that's available from very specific sources. You can't get just anything on it, unless you "hack" it and that requires a specific revision of the device.