With proper care you can get it almost flood proof - I hate to use the term flood proof because you don't know what's going to happen.
In the event of a power outage, you need to make sure the sump has enough room to handle the drainage from the tubes and whatever is in the overflow box. Also, drilling a small 1/4" hole in the return lines that return water to the tank from the sump - about a quarter inch under the water line, prevents back-siphoning.
You can test this by doing a mock power outage (just unplug your sump pump or flick the surge protector switch off). Mark where your water line is and see if your sump can handle the drainage of water. The siphon will stop automatically when the power goes out. Then, repeat. Continue to mark the water line in the sump so you know where your MAX fill line is. I did this and then lowered it by about an inch to be sure I never overflow the sump. I marked with a piece of scotch tape on the outside of the sump since it is see through.
Then, if for some reason the siphon breaks without a power outage, make sure you have enough room in your display tank to accommodate what is in the return chamber of your sump. Your biggest problem here if you have enough room in your display tank to handle the water is your pump running dry and burning the motor out.
Here's a good link:
Melevsreef.com | Acrylic Sumps & Refugiums