The “digital devices” tuners are pretty solid.
I would not suggest getting the PCI express tuners as the driver situation is just as bad as with the other manufacturers, but if you get their IP tuner you should have something that lasts a long time.
The relay will cause a short voltage drop when switching. This could be a problem if your circuit can’t handle a short voltage drop.
Probably the Mean Well has adjustable output voltage. If you can trim the output voltage of the power supply to a higher voltage than your battery, then you can probably just run each power source through a diode and merge them after the diodes.