I agree that there is probably a design flaw/oversight if there are that many NULL's.

However, if a column in a table has values that are REALLY lopsided, like a bit column with 99% of values set to one value, then an index is helpfull in some cases if you are only querying for the 1% of the other value. This has been useful to me on some megamillion record tables.