It depends on the grounding model you adopt. A grounding model with purely DC resistance is applicable in cases where the longest length of the grounding system conductor is less than 10% of the lightning penetration depth.Ground resistance has very little if anything to do a good LPS. A 10 foot section of 750 MCM exhibits roughly 3K ohms of impedance at lightning frequencies. Does not make one bit of difference if the earth electrode is 1 or 100 ohms if it is in series with 3K ohms. Either way you still have 3K ohms.
Operating the switchgear to cut off the supply during a ground fault in a substation is one thing. Obtaning lower GPR (ground potential rise), lower touch and step potentials due to lower grid ground resistance is another. Which you prefer, one or both?As for a sub-station even though they are designed to obtain 10-Ohms, anything 200 ohms or less is more than adequate to operate the switch gear. However that has nothing to do with life safety as not even a 1 Ohm ground would save your life, it would only make you vaporize faster.