As I have reason to know from recent experience, drug users will ::gasp choke:: use drugs. The place where they do so is a matter of convenience. I, personally, think the drug laws are stupid and counterproductive -- but there they are.
This law, as written, does not require that the family be kicked out if a member uses drugs. It does, however, allow managers of the housing complexes to make such a rule. It's a pity the whole thing wound up in the Supreme Court; it sounds like we had a hardass manager who made the whole thing worse than it needed to be. But if we're going to have a War on Drugs, this sort of thing makes sense as part of it.
Whether the War on Drugs makes sense, a priori, is an entirely different kettle of disgusting substances.