As something that I've probably spent waaaaay too much time pondering, the conclusion (such that it is) that I've thus far reached matches your own observation that the more one learns, the more one realizes that your understanding of the great scheme of things is likely minimal.

However, that sense that each step I take brings me one increment closer to grasping some greater handle on that entirety, is something that I find ultimately drives me onwards, rather than causing paralysis over the apparent hopelessness of ever gaining full understanding.

What makes life/existence/consciousness both simultaneously terrifying & fascinating is the simple fact that I don't have the answers. If there is a point, surely finding those answers as they pertain to you, must be it?