I've always taken it to mean a shot of something invigorating

A "shot in the arm" is not to be confused with a "shot in the dark" which is certainly invigorating, but only if you hit something.

Now, "a shot heard round the world", that is always invigorating.