The now 40-year-old soccer star looked as youthful as ever as he proposed to partner Georgina Rodriguez this week