Sports are often seen as the linchpin keeping people in pricey cable packages, but a recent survey found most subscribers don't need games to keep paying for TV. Plus, many sports fans would pony up for streaming.