You're right. The timelines are so long, I'm pretty sure more than a few exciting and really expensive space missions you will not see in your lifetime. We are at hundreds of years from real space colonies.
Why should the future care about you or your desires? To the future, you are simply a resource.