The story
From the image of a deer caught in a car's headlights – wide-open eyes, lack of motor reactions, etc.
Etymology from Wiktionary, CC BY-SA 4.0.
deer in the headlights
Today it means: A person in a mental state of high arousal caused by anxiety, fear, panic, surprise, confusion, or substance abuse. Full definition →