While a big retirement account balance is a good problem to have, it can come with challenges, financial advisors say.