why is CSGO so hard?

Simply put: It's meant to be.

The skill ceiling and the steep learning curve that Counter-Strike has always had is what makes the game so enjoyable, mainly because it increase its competitiveness by such a large amount.