Conversations can be difficult to navigate. People may be evasive, lying, frightened, or preoccupied with other matters. Insight is used to empathize with someone and understand their underlying emotions and motivations.
As with other passive skills, Insight is only used during conversations and scripted interactions, and otherwise has no effect on gameplay or combat mechanics whatsoever.