At the very least, having a second SPG in your save-a-dive kit is a good idea. Whether you leave it on the reg is a personal choice. And like many personal choices, it's a contentious topic on SB, as you can see.
Personally, for my dives (with no deco ceiling, and no hard ceiling): a failed transmitter or failed computer are neither common, nor life-threatening problems. So I'd be perfectly happy diving with just the transmitter and leaving the SPG topside. But, I have not gotten around to removing my SPG, and it gives me the warm-fuzzies to compare the brass SPG to my computer every now and then. So I dive with both, but may remove the SPG some day.
I have no opinion on whether SPG failure rates are higher or AI transmitter rates are higher, they both seem to fail infrequently. I have never had an SPG failure, and have never had a transmitter failure. Never had a computer failure either, come to think of it.