This is slang for posing some question or problem that a “nerd” can’t help but solve, to the detriment of everything else they need to do.
It comes from the concept of “sniping,” shooting someone at long distance who dies before they even know what happened. To “nerd snipe” someone is to give them a problem that sweeps them up in finding a solution so quickly they don’t even realize what happened.