Concorde was designed by a bunch of scientists and engineers armed with slide rules! It’s an amazing engineering feat accomplished well ahead of its time.
Concorde was also as much a victim of cold war politics as the TSR2 programme.
As great as the aircraft was it’s now too old to ever fly again and Airbus, as an engineering authority, want nothing more to do with it. Parts are not available and, in all honesty, many parts probably couldn’t be manufactured any more. All the airframes are suffering from corrosion and stress fracturing. If it needs to be moved it will be moved in pieces on the back of a truck!
The 727 still has some commercial flying aircraft around the world and Boeing were more than willing to act as engineering authority for the reconstruction.
Will we see supersonic or even hypersonic passenger aircraft in the future? Yes, I do believe we will and that has come to pass with the announcement of smaller supersonic aircraft being brought to the market.
Will we see large scale passenger supersonic transport again? Personally I don’t believe we will. The costs are too high for the companies to invest in and the passenger loads, of those passengers willing to pay the premium prices needed to operate the aircraft, would be too low. Most passengers want cheaper tickets and more regular flight schedules than shaving off a couple of hours flight time. Hypersonic travel, as promised many years ago by HOTOL would, possibly, be something if you could cut travel from the northern hemisphere to the southern to something around 5 hours but, again, it’s a very niche market!
Supersonic transportation will, in my opinion, for the foreseeable future anyway be the playground of the rich and famous and the military. :)