Most substations are defended by a chain link fence with maybe some barbed wire at the top. There are plenty of tools that could disable them, both firearms and otherwise. I can’t speak to how many you’d need to take out to collapse the national grid, but I can tell you that region wide problems can be caused with an attack on one or two. Our infrastructure is ridiculously vulnerable.