If credit card debt is keeping you up at night, a 0% balance transfer card might help, but it's not a fix on its own. Here's how they work and what to check before you apply.