Financial advisor confidence levels have collapsed over the past few months, new data reveals.