Wanting to explain this yet do not know how you are testing so basics:
One reason why a RCD won't trip is a N - E fault that is allowing a small part of the current to flow back along the Neutral. Because of this the RCD does not see the full imbalance that the test is creating.
A small enough resistance that your IR tester won't have the resolution/range to indicate it :
Q. you are showing 0.00 M ohms - Is that correct?
I have assumed you are reading this at the boiler plug.
Q. Same test using the circuit continuity setting on your MFT and a resistance reading that will be greater than the range on your continuity test - perhaps >200 ohms - Is that correct? .
I hinted at this a few posts back. I gave an example figure of 1500 ohms and asked what would this resistance read if measured using your insulation tester.
Q. The boiler once cleared from the system (unplugged) reverts all RCD's to operational. When the boiler is plugged in the RCD will not trip - Is that correct?
A N - E will not be lost isolating the circuit from the rcd by the single pole MCB
A N - E fault in circuit at certain values of current flow can stop an RCD from tripping.
It has been already mentioned to forget the lights for now.
Getting late and delayed coming back to you. Consider what I have said.
I have asked the questions here in this post because I am not clear how you are testing and where your results are being obtained. Hence the N - E situation that could be the issue that I have layed out.