The former Real Madrid star is hoping to play for many more years, insisting MLS move not a short-term deal