I think I'd use "terrified at" only in relation to a future prospect that presented itself (as in your example), rather than a general condition. "Terrified of" could apply to either. I'm terrified of spiders -- OK I'm terrified at spiders -- unnatural (to me)
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.