for me tightness is about the attack and decay of the note.
A tight pickup has fast and clear attack, with a very linear sounding note decay, whereas loose pickups are softer and not as immediate on the attack, and have a bit of bloom after the note.