
Weak at the knees
Emotional Overwhelm
Use it to describe strong emotions that impact one's physical state, not just any feeling. 
Non-literal Use
It's a figurative expression; your knees might not actually feel weak. 
Intensity Marker
Shows an extreme reaction, more than being just nervous or excited. 