Question about Google

So my site has a very good DA and I tried to rank for a relevant keyword which has at least 14k searches a month.

I went to Google Search Console and I saw the average position of the keyword was 6 and I was very happy until when I searched it, my site is nowhere to be found. Why is this? It showed me that on 9th august it was on 6 but then its not there anymore?

Does google hate my site?

It showed you 6th position, but you also have to click "countries" to see in which country. You may rank 6th in Albania, and nowhere in the rest of the world.
Also:
1. DA doesnt mean shit.
2. Google hates everyone equally.