I think faucets are probably to blame for the over 6 million wallets that have a very small amount of bitcoin. I wonder with the lightning network or some other improvement to bring down transfer costs if we'll see a reduction in these small value wallets.
I'd assume most of those small wallets are probably just forgotten and/or abandoned.