"Keep your eyes on the prize!" is something that gets touted as a way to maintain motivation.
It sounds good in theory but in practice, it can all too easily lead to disappointment, shame, and guilt.
When it comes to handstands, we can't exactly control the prize (aka outcome, or specifically how long it takes to achieve that outcome). What we can do is control the process (i.e. our behaviors that lead us towards the prize).
I say this from my own personal past experience of being too fixated on end results and the potential unnecessary suffering it can induce.
Have goals, for sure.
But mainly focus on being consistent, present, and enjoying your practice sessions.