If you're referring to the prototype of the Prometheus-class as seen in Voyager, all it's done that we've seen is get captured by Romulans, then reclaimed by Voyager's EMH with the assistance of the onboard EMH, while still in its prototype phase. Most likely it was later "graduated" to normal duty, but nothing further was seen in canon.
If you're referring to the Nebula-class Prometheus seen in the DS9 episode "Second Sight", it was used as a scientific research vessel.
The ship may have been named after a Great Basin Bristlecone Pine, found in Nevada, that was felled in 1964. It turned out to have been still alive--and over 4,800 years old (dead specimens nearby were measured at seven thousand years old). Certainly significant enough to have a starship named after it ProfessorTrek 21:41, August 6, 2011 (UTC)
- Probably more along the lines of Greek mythology. Prometheus was a Titan (powerful beings that rivaled the gods) who stole fire from Zeus and gave it to mankind. The word became associated with power and wisdom, and was the namesake of many things, like one of Saturn's moons, a volcano on Io, NASA's nuclear propulsion project, a few companies, a few superheros and supervillans, a ship on Stargate, several video game characters, and a few ships in the US and UK navies.