Many Americans say "living debt-free" would make them feel financially successful, but not all debt is created equally. Here's which type of debt to prioritize.