The only way to
always avoid overcharging AGMs is to chronically undercharge them. Nature of the beast, but if the level of constant under-charge is in the 80 to 95% range, then you are good to go.
But, in this application (tongue mounted battery on a travel trailer) where the batteries are outside (no interior venting concerns) exposed to temperature extremes, but wont be turned sideways in any normal use (AGM are generally spillproof) and the water refill ports are reasonably accessible, flooded batteries really are the most bang for the buck, very robust, easily replaceable, and almost 100% reliable, usually made in the good ol USA.
I take a different fork in the road when it comes to 6v batteries than offgrid...I recommend and use 2 12v batteries in parallel and it works fine. If one cell in one battery shorts or opens, you can still use the remaining battery for some time if needed... And if your tow vehicle battery dies in the middle of nowhere, you can drop in your RV deep cycle (assuming it has starter posts) and continue on your merry way. Virtually all class 8 OTR semi truck tractors use 4, 12v batteries in parallel. It's proven, it works, and the replacements are reasonably priced and available just about everywhere you are likely to be.
But with a pair of 6v GC batteries, if a cell shorts or opens in one battery, you are 'dead in the water'...so to speak. I know, I tried it with an old motorhome I had. Not gonna do that again.
At any rate, your choice...pros and cons for each solution.