How do you balance living practically, with reaching for your dreams? How much does material gain matter, realistically?

I want to hear what really matters once you've well advanced through life? Do you wish you'd taken the leap, or treasure the security of your life?