The real issue is that food isn’t really important from what we’ve seen so far, outside of mutiny, so there’s only tension related to running out of money. You could circumvent this by adding ways to use supplies as a resource, rather than just having them passively go down. Such as arriving at a city and discovering that the people are starving as a result of raids on the farms. If you don’t share your supplies the militia get weakened even further, running the risk of the city getting razed if you don’t put a stop to the raids. That would also give the player different ways of dealing with a problem: give away supplies so that the militia can fight the raiders for now, deal with the raiders yourself or hope things will work out somehow (or maybe lure in another faction to deal with them?).
This idea sounds great, and could easily be considered for the event system. It has a strong FTL-vibe to it, where you would often encounter beacons with people in need of a ressource and you would have to deliberate whether you can give a good chunk of your fuel or rockets up for what might be a great reward like a crewmember, a special weapon or intel on the sector (though sometimes it would turn out that you get nothing but some beamweapon shots to the hull by some pesky pirates^^).