Do you not have other keys? Or like, is it up to Amazon or whoever, along with battery electrochemistry, to let you into your house, too?
(“Physical, metal key”. That actually makes me incredulous, to be honest, as if carrying three grams is a burden. Are we just a parody of ourselves now?)
By "physical, metal key" I'm just disambiguating between key fobs, key cards, phone-keys, and tumbler keys.
If you run out of batteries completely and need to get in the procedure is:
1. Open a small panel on the front and apply 12V to the emergency cables to unlock the frunk (this only works if the car is powered off as I understand)
2. Jumpstart the car's low voltage battery, located under a panel under the frunk
3. Unlock and open the door normally
4. Attach an EVSE charger to get the HV back online as well
Only the front doors in the Model Y[0] and Tesla warns using them "May cause damage to the window trim."