I wasn’t remotely prepared for how much more difficult this was compared to the left Joy-Con. I ended up ruining the entire unit trying to reinsert the ZR cable into the zif connector.

I agree, it sounds like it’s not a battery issue. If the right one doesn’t work even when attached to the console there’s probably a shorted or broken connection in the power circuitry of the motherboard.