Controversial opinion: I do not like the obsession Trek has with making being a starship captain the only career choice for characters as though they can never change.
They have moved away from that also it's not really been a big thing as I think people think. TNG you had only Riker with a desire to become Captain someday. Maybe Wesley but Wesley always seemed more into engineering. Granted we did see Dr Crusher become a Captain in "All Good Things" but that never felt like a strong desire. On DS9 you did have Worf switch to command and I guess maybe Nog also with a desire to become Captain.
Voyager I guess Kim was the only one who seemed like someone who would want to become Captain.