Yes, buddy, it's possible for an average airdrop hunter to make $10,000. I mean, just last year alone, I know a few friends who made up to $8,000 from airdrops like Grass, and some made up to $10,000 from Zion. You can bet there will still be people making that kind of money this year as well.
As for the amount that can change someone's financial situation, it really depends on the person. Like you said, some will get $100, go into trading, and flip it into $10,000—completely changing their life. Others, however, might just spend the money because they lack the knowledge to make more in this space.