No, you can use rca or s-video to input a console to the tv card. Just don't expect the picture to be better than on a tv.

Another good line of tv cards is the Hauppauge WinTV line. http://www.hauppauge.com/