And it is still there:
Had that shell, fired from a Blakely rifle on the CSS Alabama, exploded in the USS Kearsarge‘s sternpost, the outcome of the action would have been different. The gun that fired it….
…was recovered from the wreck in the 1990s.
The US Navy History and Heritage Command has a resource page with more information on the Battle of Cherbourg.