You’d need a separate cable box to watch something different in another room. All channels were sent down the same cable, and the set top box decoded the stream and tuned to the right channel.

I haven’t had cable in a decade, but I doubt that’s changed much.