CurseForge shares a slice of their ad revenue with creators, so getting money simply depends on how many people visited your page. Even if a mod is unpopular, you still get a minuscule amount of money.

I should mention that you get paid in "points", and these points can be used to redeem money. For example, every 100 points = 5 USD.