I am not that well versed in crypto. I understand the concept of a blockchain and what an n block reorg is, but what is the downside of a reorg? Like who can profit financially and why?

You get all the money from the block rewards for those blocks if you reorg other miners blocks out.