there is a word when in a greek drama the hero finds out that everything he believed in is wrong, does anyone know?

I think the word you're looking for is 'hamartia'.

thank you, that is exactly what I was searching for.