Although I have used an active RCD as a no volt release unit, that is not what they are designed to do. In some cases it can cause danger, I had it where a mag mount drill fell off due to loss of power, the required chain stopped it falling to the floor, but it still dropped a foot or so.
OK, other factors as well, the generator dropped to tick over as the magnet not drawing enough current, so a work lamp bulb failing caused it to drop.
But you must do the risk assessment, I don't mean writing out a form, but look at what might happen, if the pump is auto powered up. Be it soak the cat lying on plants, or something which is not quite as funny. Cycling, I was not amused when an irrigation started up as I was passing it. Should have realised that was why the road was wet, but I didn't until too late.