> Upwards of 90% ... of software should not exist ... it has not meaningfully contributed back to the enterprise

This is Sturgeon's law. (1)

And yes, but it's hard or impossible to identify the useful 10% ahead of time. It emerges after the fact.

1) https://en.wikipedia.org/wiki/Sturgeon%27s_law