It sounds like you had an obviously valuable service that if you had sold, could potentially pay for itself, why was the instinct not to create a paid version of the API?

If you can't find enough people to pay for it, then shut it down, but if you can, then you have a solid business. Of course, you'd still have to take down the public API (since it would be no longer free, and grew unsustainable), but...