It should only be for purchased videos, most likely full films, tv episodes and music vids. It's a form of DRM, so that you can't share purchases videos and music with your mates.
I have two ps3s, I start watching a film on one.. Deactive the video feature on one and active it on the other to finish watching it in bed.
It doesn't affect streaming media just downloaded stuff.