Does Cindy McCain's past drug habits threaten the safety of the White House if John McCain was elected?

No, not any more than Bush's former addiction and alcoholism threatened the safety of the WH. In any event, it's a moot point since McCain will be staying in the Senate.