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.
On the other hand, the more missions/programs start now, the more excitement there will be in the future when they're being completed. If companies and countries keep at it, it will soon be a long string of space missions in the news.