DIY BNC to F-connector or RCA?
Assuming it's a normal composite video CCTV camera (most are). You should be able to splice on a RCA connector and plug it into the composite input of your TV.

Splicing on a F connector and plugging it into the antenna input is not going to work.