Interesting. I imagine that we may well be talking (dirty) water here (rather than 'insulation'), which may possibly afford some of the explanation, perhaps via electrochemical mechanisms. I wonder what it would have shown at 230V (or even 500V) DC.I am replacing the float valve in a domestic pumped sewage system. It is the type that "swims" of the surface and has three switches. At 9 volt DC there is no fault, IR looks > 200 Meg. At 50 volts DC it is about 7 Meg But at 230 volt AC the IR drops low enough to pull in the pump motor's control contactor ( the fault that caused the pump to run dry and wreck ). So yes IR values do tend to change depending on the test voltage applied.
BTW, to surmise an IR which "looks >200MΩ" at 9V implies that you can measure current down to about 50 nA - is that the case?
Kind Regards, John.