What you actually need is islanding equipment which discharges the battery for local use only, but cuts off (or islands you from) your main incoming power connection.

Many of the PV systems you can buy from the big players (SolarEdge, Tesla and more) support this, often calling it "whole home backup".

Same principle as having a generator with an interlock.