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.
Never flew in a Concorde, but I've been inside a grounded one, at the Museum of Flight near Edinburgh. Not sure if they still have it or not, this was some years ago.
It's so small inside! I mean, I'm a tall guy, but even allowing for that, it was horribly cramped and generally not very nice inside. IIRC it had a brown and cream colour palette, and not in a tasteful way.