I would possibly say that it is rational to modify towards having your own set of goals, but whether those goals are ambitious or not I think depends on what you value in life? As in - I think the "intelligence" part probably allows you to realise that it is possible to have many different types of goal in life and that working towards a set of goals that work for you personally is important, but that those goals can be defined by what you yourself value.
The most intelligent guy I know wants to have a family, work on somewhat interesting problems (in chemistry if it matters) but not work huge amount of hours, so he has set himself up to have a regular consulting gig that he can do from anywhere and still focus on spending time with his family.