I have a tv hookup in BR. If I connect a cable to it and put up antenna, I get "over the air" reception. If the campground has cable at the post with water/electric and I connect a cable from my fiver...
My 98 Cameo had such a switch. Your 02 certainly should. The only exception I know of is trailers equipped with a Winegard Distribution Center (a large black box with a bunch of push buttons on the front and a nest of connections on the back) which contains a booster that is automatically connected to the correct inputs.