Exactly. Distance in time means greater uncertainty of reward, and greater uncertainty means lower motivation to go after it in the first place.
In fact, it is often wildly different from the known rational answer. In other words, we have some hardcoded responses to scenarios that are probably built on evolutionarily rational behavior, but which don't apply well to specific scenarios in which the "correct" rational behavior is easily determined.