In this case you are right, a tight shot is like a close up. If it's a tight shot of someone's face, for example, the face fills almost the whole screen so the space is very tight. It is used for video and movies mainly, not so much for still photos taken with a camera.

Tight in this case means there is no room for error.