What's so special about commanding a ship named Enterprise though?
was widely regarded as Starfleet's most famous ship by the time Riker was in Starfleet. More than that, the ship was his home for more than fifteen years. Its crew was his family. Why wouldn't he want to captain the vessel he'd once served on as first officer?