The G’s is totally a function of the frequency being produced and the modulation and there is a calculation for it - read this article - Dr. A. M. Max, Disc Phonograph Records, Max, RCA Engineer Magazine 1966-08-09 1966-08-09.pdf which also calculates the force from a spherical stylus of different dimensions and different VTF, and the "calculated" forces at 2.5-gm VTF can range from 65,800-psi to 121,300-psi. However, the G-forces developed have only a minor impact and it’s because of the very low effective tip mass with modern cartridges being very low Effective Tip Mass | myhi.fi.
Note that the record does deform under the forces of the stylus, but provided the forces remain in the ’elastic’ region, no permanent deformation occurs. However, if the stylus mass is too high (generally considered >5-gm), then the forces exceed the elastic region and ’plastic’ deformation can occur. The Dr. Max article addresses the elasticity of the record with greater detail in this article - Groove Deformation in Gramophone Records.
FWIW, on a different but related to records, this very recent article 2023, is excellent on the subject of tracing distortion Tracing Distortion on Vinyl LPs
VLADAN JOVANOVIC, 22236.pdf.
Take care,
Neil

