You would always have the captain looking inflexible or downright stupid in order to focus on how great the first officer character is.
Sure, if you write it like that.
Or you can go the route that many sci-fi and fantasy books go and have a strong "leader" character who the main character emulates and learns from via trial and error. Rand Al Thor of the Wheel of Time
series starts out as a bit of a whelp who's led by both a strong woman and her bodyguard. Luke from Star Wars isn't too different in this regard in the first 2 original Star Wars movies - he's the main character, yet is guided by wiser, more experienced characters. Same can be said of Bilbo and Frodo Baggins, and the person they follow - Gandolf.
A bad idea, really? The "leader" character would have to
be "stupid", really? C'mon now.
Centurion: "...power is danger."
Romulan Commander: "Danger and I are old companions." - TOS episode Balance of Terror
"Living in your dreams is like living in exile." - Calyx, A Stitch in Time
"Shame on you, Barack Obama!" - Hillary Clinton
"It's the economy, stupid." - Bill Clinton