Destroyers and frigates are currently named for military heroes (I think almost exclusively Navy and Marines) so USS Puller would be more appropriate for a destroyer or frigate (actually, there was one. She was an Oliver Hazard Perry-class frigate in service until 1998 when she was sold to Egypt).
Nimitz-class carriers have been named for Presidents, one admiral, and several other politicians. Not "famous people." I'm not sure Patton or Yeager fit this convention.
The historical tradition for carriers is to name them after battles (IE Yorktown, Lexington, Midway) or previous famous ships (Enterprise, Hornet, Essex).