Yep 400KΩ is not enough to trip the RCD but didconnecting the blue neutral leaves the RCD holding ok. I fully expect expect a very different reading using insulation tester.I remember looking at a compressor, using my multi-meter on ohms, and reading seemed OK, but returned with my mega and it showed short circuit. If multi-meter not showing infinity, then likely a fault.
Twas my instant assumption until I started unpicking the bundle. I was hesitant to do so but the other downstairs lights are horrible Ikea stuff and ba****ds to fit so I avoided touching them which thankfully proved to be the right move.If you had not showed the switch drop, I would have said three core used for that,