Welcome to marketing :-).
But in all seriousness, in the scenario you describe above, I'd question if X belongs on your resume at all. If you did it, and it was worthless, is it something to brag about?
There are no doubt exceptions to this, where something is really technically interesting, but honestly, 99% of the time, what you did is just not that novel; you are better off leaving it off your resume and instead demonstrating your skills with something where you delivered value.
It's also worth noting that even where X flopped, you still hopefully contributed something positive. In your own example, you delivered X some (months?) early. That alone saves $.
I was once part of a Salesforce (god help me) implementation where we were moving all our analytics into this new Salesforce platform with the idea that it would be the central hub for all employees. When all was said and done, it flopped. It tried to do too much at once, be everything to everyone, and was useless for most. 80% of employees only logged in once. It was exactly as you describe, where from the beginning, I warned we were on the wrong path.
It doesn't usually land on my resume because, I mean, it's fucking Salesforce, but if it does, or if it comes up in an interview, I can talk about how I replaced our contractor's ETL with a custom one that ingested the data in 10% of the time making it possible for us to actually keep our data up-to-date, or how I was able to refactor the data model to take proper advantage of compression and save us around $30k/month in storage costs (Salesforce cloud storage is stupid expensive).
Sure, the whole thing was a major screw-up that literally cost the company millions, yet I can still talk about how I made that situation a little better.