Oh, man, to be honest, I don't think it's a good idea because you'll spend too much time on that, and the chances of you becoming good enough are small. You should consider other ways of profiting, and I can recommend you start selling skins on platforms like https://dmarket.com/sell-csgo-skins. If you're into games, then it can be a great source of income for you.
I think it's possible to become a CS GO cyber athlete nowadays, but it would require a lot of dedication, hard work & best skins https://knifex.com/pages/cases.