Morning Stu, I hope you had some stands under there when you clipped that wire up! Anyway, your water ingress sounds suspiciously like blocked sunroof drains or possibly windscreen seal, especially if the scream has been replaced in the past. Given the age of your Range it’s a fair bet.
You have...