Something that I don’t feel has been mentioned in this thread is the option (and importance) of practicing oral inflation of the BCD. Especially in a single tank rig, you can plausibly have a double buoyancy failure if you lose your only gas source (for example, tank valve isn’t open on descent). This is solvable while using someone else’s reg, providing that you’re comfortable orally inflating your BCD.
Orally inflating the BC is super important. I do practice this regularly*. I guess I had never considered a loss of buoyancy due to an out of gas situation. That's interesting. I think that, for some reason, I've been focused on a double buoyancy failure at the deepest part of the dive, but everyone here so far is right: a double buoyancy failure is going to be exceedingly rare, I have other buoyancy options (like a DSMB), (on the surface) the gear I'm carrying shouldn't be any heavier than a large backpack that I should be able to get out of my rig, and I have a team who can help me all of those thing.
---------------------
*I hadn't set out to intentionally practice orally inflating my wing. I had a particularly minor, yet irritating equipment malfunction that led to this.
On my rig there is a large rubber o-ring woven between the webbing and the tri-glide that holds the left chest D-ring. This o-ring is the retainer that holds my low pressure inflator valve against the webbing to keep the inflator from floating around and becoming a flappy snag hazard.
When connecting the low pressure inflator hose to the inflator valve, the quick release collar would often work its way into a position to be directly above this rubber o-ring retainer.
For almost a year, every time I lifted my inflator over my head to descend at the beginning of the dive, the rubber o-ring retainer would roll against the quick release on the inflator hose, popping it off of the inflator valve. I wouldn't know this had happened until I approached the bottom and went to inflate my wing only to find that my descend wasn't slowing.
The first time this happened, I was on vacation in the Caribbean diving in a wet suit. My only option was to orally inflate the wing at depth, inhaling from the regulator and exhaling into the wing. When I was finally neutral, I was able to take a moment to assess the situation and reattach the inflator hose.
Since the only time I ever raise the inflator valve over my head is when I'm descending from the surface, it didn't matter how the inflator hose was connected for the rest of the dive. It worked fine during the dive, but sure enough, on the next dive, it would pop off again.
I have since finally learned how to route the rubber o-ring retainer around the inflator hose to prevent this problem from happening, but thanks to that problem, I am now super proficient at orally inflating my wing.