There are conflicting opinions on this.
More things = more failure points = bad.
SPG + Transmitter on the same tank doesn't add much. Both can fail, having 2 has zero added value until one fails which is more likely to happen if you have 2. Regardless, the dive is over.
Having doubles and SPG/AI on both adds something, since you can monitor 2 (manifolded tanks), but added value is minor:
In case isolation is necessary, you can still check both tanks, that's a plus, but the dive is over anyway.
An SPG is easier to quickly check pressure before a dive, since no electronics needs to start up, another minor plus.
So a bit more convenience + more information in one case of failure, versus higher likelihood of another failure.
This combined with a the SPG being a piece of non-critical equipment causes the conflicting opinions.
According to 'plan your dive, dive your plan' + experience, you should know exactly how long you can dive before you are low on gas. The SPG is only extra confirmation, and a bubble check should already confirm that no gas is leaking. I am confident that I can do most of my dives without an SPG, as long as I can check the tank pressure right before the dive, because I know how long I can dive at what depth with one tank or set of doubles.
Still, I carry 2 AI computers, one set to gauge mode. The main reason for that is that I first was using a Suunto Cobra which is AI through a HP hose, which I later replaced with a Perdix AI. I was considering, as you are now, to use a backup SPG. I was also considering using a backup computer since I do technical/deco diving. The Cobra was perfect for this, since one tool covers both. The perdix is my main, the Cobra tags along. I usually use the cobra to check the pressure before a dive, and after about 150 minutes I usually compare both tank pressures once just to confirm that they are similar. But mostly it is there only for backup SPG AND backup computer. That way I have extra redundancy without extra risk or bulk.
For 'holiday' diving in warm water with a single tank, I would probably bring take the AI computer and just pack a hose and SPG. If it fails, you can estimate how long you can still dive and end the dive at the safe margin thereof (assuming no gas leaks). If it is for whatever reason not repairable, swap with the SPG and do the rest of your diving like that.