Concorde flights came to a screeching halt after only 27 years of operation on October 24, 2003. The reason? Excessive cost, high fares, and loud noise. On a regular flight, Concordes consumed 6,771 gallons of fuel, which quickly exceeded the profit made from the flight. In addition to that, only a total of 20 Concordes were built and no airline ordered them except for Air France and British Airways, who had to as they were state-run airlines at the time.
Oh, and a 2000 crash that killed everyone on board (109 people) and four people on the ground.
Boom supersonic is trying to bring supersonic passenger flight back. They have a test bed prototype that flies out of a Colorado airport. But last I heard they were in big trouble without an engine supplier.