Thankfully, we are shown moments where Picard was very wrong with his "wisdom". His speech about stopping the Borg and making them pay in First Contact. The forced re-location of the native american tribe in an episode of TNG (notice his stance on forced relocation has totally changed in Insurrection?)
Grand words are still just words in the end. It has been shown that Picard has been wrong in the past. And going from the events of Insurrection, that he can learn from these wrong choices as well. Although I wish there was a line of dialog that referenced that episode in the movie, showing some character growth.
