[Warning: HD evangelism ahead]
It really depends on how far away you sit from your TV, what the screen size is, and how good your vision is. When I'm sitting three feet from my 28" HD monitor, you bet I can tell the difference between HD and SD. My vision's not quite 20:20, though, so on the couch 15' away from a 100" projector screen, I'd have a hard time telling 720p from 1080p just based on sharpness, but the larger size of any macroblock artifacts would give it away.
In the right conditions, I'm positive you'd see the difference, too. Try renting both a DVD and Blu-ray of the same movie from Redbox, and watching them a little closer to the screen. The Blu-ray will let you see more individual hairs, individual distant bricks, etc. But even SD on an HD screen can be better than SD on an SD screen, due to increased pixel density and reduced flicker.