yes indeed, the underwater "sand" is lighter than the dirt above the water, but that's intentionally so.
I've seen a stream have lighter underwater material (like sand), whereas above the water, there was a more brownish "soil".
You're right in that this is not usually the case.
Cheers,
Frank