If people are asking/begging for the tool to be open sourced, then they do indeed value it. Otherwise, why would they care if it just withered and died?
They may not have valued it as much as the product was charging for, but that's a different debate entirely. I'm assuming there was some discussion of commercial viability, lowering prices, etc. before they chose to shut down. (You pretty much said this part in your second paragraph, this is the "execution" part.)
If we are talking about a start up, what about current clients? Maybe your business could not be sustained by the number of clients you had, they do find value in but they can not by themselves sustain your business.
They have time to contribute back through documentation, bug reports, and even bug fixes. The only thing they don't have is money. That doesn't mean they don't value the project.
There might be no/little value in the product but some probability of value in the source. For example, for a competitor there is possibly a lot of value in seeing the approaches the software took, the problems the developers ran into, etc. Key word: Possibly.
I'd personally just ask to interview the startup owner for 10 hours at say $200/hr but I know some people aren't great at extracting value from a face to face chat.
It's a good thing my kids pay me to love them.
Markets are not only not omniscient, they're remarkably easy to influence if you're one of the relatively few people who understand how to do effective marketing. (I'm not, but I've certainly experienced people who are.)
Ability-to-persuade usually trumps ability-to-deliver. Even in tech.
So what's the real value of a product/service?
With a failure like this, the lack-of-value may have been as much about the failure to upsell and market correctly as about a lack of practical usefulness.
I can see it being rude for people asking you to open source an ongoing concern side-project. But if your startup failed, your application didn't have any value in the marketplace (or you weren't able to execute).
As you said: "If you don't think something is worth money, you don't value it at all." If the market doesn't value it, and it failed, why would people pay to open source it?