Sort of? It was a startup that went bankrupt before building its first product. The light bulb was also "tried" 50 years before Edison. There's something to be said for trying again.
But I wonder if Cargolifter would still be such a dud in today's market? Just look at the crazy lengths companies go through to put the largest possible wind turbines in remote locations. Seriously, if you've never done so (or if it's been a few years), enter "turbine blade transportation" in the image search of your choice and be awed. I can't imagine Cargolifter not having a waiting list measured in decades given the pains ground based blade transportation goes through, and those things aren't even that heavy. Currently, inland wind turbine size is clearly limited by transportation, not by materials or engineering. (and larger turbines are actually less annoying than smaller ones, because rpm go down with size due to blade tips approaching transonic speeds at any non-trivial size)
Right, but sometimes the only way for it to change is for someone to burn through enough money to drag the market kicking and screaming into embracing a new/better type of products. Recent example: Tesla and electric cars.
Whether or not something would be a useful/successful product, and whether the market can, on its own, get to that point from where it is now, are two distinct considerations.