I don't think everything should be measured by its commercial success.
After all, the moon landing never made any money!
Concorde was a project that pushed the boundaries out way beyond where they were. After all it was only 25 years after the jet engine came into being and it was going at twice the speed of sound.
Formula one cars, the channel tunnel, hybrid cars similarly do not make money. Often it is not until the second generation that the bean counters get a look in. Concorde was a product of its age and the situation changed (the oil crisis) which made any further development along that line unacceptable.