It's often better than a 5 Mbps 1080p
Now, when compared to blu-ray... That's different. Very, very different.
I would take crisp 480p over a gooey, artifact-softened 1080p for most content.
It's certainly blurrier than Netflix, but dark scenes, grain and textures are usually much more detailed on a DVD nonetheless.