Agamemnon sacrificed his own daughter?

I was devastated when I read this, and wanted to know your point of view what was it really needed to be done because the whole idea to save his royal pride in order to retrieve Helen, him killing his only daughter was that the only way?

Also can you tell me what other great sins committed in the greek mythology I would like to read about them (strictly for educational purposes)