Hidden Closed Loop Intake

[golf nut]

If what you have drawn is correct, then as the power goes out the overflow would fall to the level of the standpipe going to the sump, the water in the tank would force water back through the pump and into the overflow which would go to the sump.

you are correct, the tank will drain to stand pipe level.