This is a common trap that people fall in while trying to understand the problem. It's not that they chose the "wrong software", it's that they tried to scope

This is a common trap that people fall in while trying to understand the problem. It's not that they chose the "wrong software", it's that they tried to scope every aspect of custom-designed software ahead of time. Imagine if you had to describe in exact detail every possible aspect of a mission to Mars in 1940. You are guaranteed to wind up causing the death of everybody involved, because there is an enormous amount of research standing between where you are now, and having enough information to create a workable design. The real problem is that the nature of the contracting system doesn't allow for open-ended / minimum-viable projects with iterative development, you have to do your best to write the requirements then throw it over the wall and hope for the best. Of course you're going to wind up with a mess.