Looked like a WWII general's uniform to me. I agree it seems odd, as Picard is the history/anthropology buff.
that said, I think the pilot's theme (but not plot) was pretentious. Why would some omnipotent choose humans to be their rivals and successors? I think this reeked of the Great Bird.
It kind of flies in the face of the ideals behind the Federation and gives credence to the "Homo Sapiens Only Club" concept.