No. It will play as clearly as the weakest link in the chain. So if you had component between your Wii and your VCR, but only RCA between your VCR and you're TV, you're just wasting your time.
Chances are, if you don't have composite inputs to your TV, then your tv won't do 480p anyway.