Composite video ... therefore has lower resolution than S-video.

Just to be clear, he doesn't mean 640x480-type resolution, he means the picture on the screen is less clear; the number of pixels, as it were, is still the same, just less defined.