The Madrid superstar is confident Spurs' under-fire manager will turn the club's fortunes around and guide them to a Champions League finish