I steered
@Joesmoe towards the speed sender to begin with, via text message inquiry earlier this morning.
(all of those non-functions are associated with the speed and the CANBUS error was while turning on key-switch with the instruments disconnected)
The water is a red-herring and not relevant to the issue, which clearly as discovered is the broken sensor harness.
Also answered, before even seeing these pics just now, that the liquid tape was probably not cured before heat shrinking over the cluster of all three wires and the exposed soldered joints have undoubtedly shorted together. I'm sure if you do another ECU error check you will probably still have the sender error.
I would re-repair and use heatshrink over each joint individually - it's also a good idea to stagger the joints so they do not line up directly next to each other.