This idiom or expression represents:

Sign of hope.

When someone says “I see the light at the end of the tunnel,” they mean something like “I am optimistic, or I have a feeling things will be getting better soon.”