The original was an actual navy ship long before Star Trek. An aircraft carrier that served from WWII though Vietnam, she is now a floting naval museum in NYC.
Actually there were probably Intrepids before her… the name has a British ring to it.
The first USS Intrepid was a vessel captured during the campaign against the Barbary Pirates. She was the ship used to burn the USS Philapelphia after that frigate had been run aground and been captured. Later she was converted to a bomb vessel, and lost in an attempt to destroy the rest of the Tripolitan fleet in harbor.
For me it is the old Spanish ship that was captured by the buccaneer Sir Francis Drake: the Nuestra Señora de la Concepción, better known in history as the Cagafuego (or Cacafuego).
It was the nickname the Spanish sailors had given to the ship. It was so famous that the original name is usually not mentioned when the history is told.
I’ll second those who’ve already voted for USS Carondelet, USS Monitor and USS Constitution. I’d add USS Lexington, USS Saratoga, USS Amphitrite, USS Yorktown, USS Gettysburg and USS Kearsarge, each of which have a lot of great history behind them.
HMS Endeavour, HMS Discovery (both honored by U.S. space shuttles), HMS Agincourt and HMS Trafalgar have some particularly good mental associations, as does HMY Britannia.
The Pillar of Autumn was the starship from the videogame Halo; I always thought that was a cool name.
Damn you. We get to three pages and no one had mentioned it yet, and I was all like “yeah, I get to do it!” and then you did it. You stole my moment, you bastard!
But another good name from Halo is the “Truth and Reconciliation.”
I’m adding my vote to HMS Iron Duke, too - our friends son is a gunner on board, and every time someone uploads a video of Iron Duke blowing holes in a drug-running boat, I imagine him having a great time.