bad idea, RCA uses an impedance of 75 Ohms, which you fuck up when you splice the wire. I'd recommend using RG6 cabling for the video, and, if possible, S/PDIF for the audio, but in lieu of that I'd ...
You have to use a VCR, or a cable box to tune the channel, and then output to RCA. AFAIK, that dongle is for digital audio.
We may receive a commission on purchases made from links. A wall-mounted TV is still an incredible look for a home theater, but this kind of setup can quickly become unsightly if there are a lot of ...