It is possible that only needing one tank rather than two can make up for the dramatic loss of Isp we see from an air-breathing engine and the air-handling structure, but no one has yet managed to demonstrate that, and the general consensus runs against it. I recall reading that HOTOL (https://en.wikipedia.org/wiki/British_Aerospace_HOTOL) calculations were actually driven by an extremely light structure estimate rather than the airbreathing engine, to the point where if you plugged a rocket engine in they would actually get more payload to space as a SSTO, because those aggressively light structure estimates were doing all of the work.
Therefore nobody is ever going to invest the tens of billions required to develop a rocket based SSTO.
If somebody develops an engine that makes air breathing most of the way to orbit feasible, this has a chance of competing a Starship style architecture.
For the reasons you espoused, this is highly unlikely. However "highly unlikely" is more likely than "never".