Do I really need a redundant sump pump?
Only you can answer if it's "worth it".  I would imagine if it did flood, the damage would be more than $400 and you'd be kicking yourself that you didn't spend that $400.  If you die at 100 years old and it never flooded, I guess then you could say it wasn't worth it.