The satellite feed will get you channels from the satellite when hooked to the appropriate receiver. Some of those happen to be "HD Locals" but they are satellite channels just like the rest of them.
The RF feed from an antenna will get you analog or digital TV channels when hooked to the antenna input of a compatible device (receiver, TV, etc).