Ambition is an idol on whose wings great minds are carried only to extreme to be sublimely great or to be nothing.
I certainly wanted to maintain some sense of mystery about Picard and that's why we never allowed certain situations to fully evolve like the relationship between Picard and Beverly Crusher.