-
The only time I've had to do anything with di2 wires in 7 years, other than dismantling the bike for transport or, in this case, adding a longer wire to accommodate a new rear mech, was when I went over the bars, snapped a bar end shifter off and the broken wires shorted the battery.
Once I'd worked out what the issue was, I plugged in a battery pack to recharge and got going again.
People's experience varies, and I've used it mainly on road, so not in as harsh an environment as you, but I've found it really resilient and reliable. What goes wrong with the cables? Connections come loose? They seem really tight to me.
One big advantage of Di2 for me, which shimano has just designed out with their new version, is ability to charge on the go.
I run AXS on two mountain bikes and cabled XTR on another- the electriconic drivetrains need the battery charged every now and again, the cable setup needs regular fiddling.
For me, in muddy and dusty conditions with a lot of vibration and some fairly regular big bumps- AXS just works.
Running on Shimano cassette/chain/crank.