Me drive bus.
NFO work with majic doohickes in back of bus
The right seat gets into the act especially during EMCON recoveries. The E-2D is likely to involve the front cockpit even more by using the front seat as another station (a la EA-6B) so don't think you'll just be driving the bus.
As to career progression, here's CAG-3 (an E-2 pilot) in 2008
080114-N-2984R-141 PERSIAN GULF (Jan. 14, 2008) Capt. Fredrick Pawlowski, assigned to the "Sea Hawks" of Carrier Airborne Early Warning Squadron (VAW) 126 [actuall, he was CAG at the time] pilots an E-2C Hawkeye off the flight deck of the Nimitz-class nuclear-powered aircraft carrier USS Harry S. Truman (CVN 75), marking his 6,000th logged flight hour as a naval aviator. Truman and embarked Carrier Air Wing (CVW) 3 are underway on a scheduled deployment in support of Operations Iraqi Freedom, Enduring Freedom and maritime security operations, in the 5th Fleet area of responsibility. U.S. Navy photo by Mass Communication Specialist 3rd Class Ricardo J. Reyes (Released)
080507-N-2858S-063 RHODES, Greece (May 7, 2008) Capt. Fredrick Pawlowski, commander, Carrier Air Wing 3, tours a group of foreign dignitaries and invited guests from the Island of Rhodes around the flight deck of the aircraft carrier USS Harry S. Truman (CVN75) during a sunset reception. The reception was held to thank the Island of Rhodes for hosting the carrier during their most recent port visit. Truman is assigned to 6th Fleet and conducting theater security cooperative activities in the eastern Mediterranean. U.S. Navy photo by Mass Communication Specialist Seaman Justin Smelley (Released)