When I first put a 9" under my C4 (2014) I had a 3.89 ratio 28 spline small pinion Motive street gear in it. Setup in a Yukon aluminum thrubolt case. Car weighed 3150lbs, 1.80 Powerglide. SBC on nitrous. Ran 1.20-1.23 60ft on 28x10.5s and 5.30s 127mph in the 1/8th.
That little street gear lasted a year with 28s and then the second year I switched to the 275 Pro Radial.... same 60fts but half a season later it was howling like mad. It lasted the rest of the season without catastrophic failure but the drive face on the ring gear was cratered. The pinion never twisted or anything..... I would not worry about the pinion shaft but the hard ass gear will eat itself with that kind of power and weight.
I now run a big pinion Pro Gear but also made the switch to a 1.69 Powerglide and 4.29 rear ratio. Its been in there since 2017.... Of course the car has also gotten considerably faster over the years. It's running 1.15 60s like clockwork now....
If you're just going to 1/8 mile race a 1.48 second gear leave TH400 and 4.30 rear would work well. The similar gear swap made my car faster and more manageable... but it'd be miserable for any real street driving. Tough choices.
Will