Should the End User Assignment Agreement be in English?

No, the End User Assignment Agreement may be in your local language.

However, there is an example End User Assignment Agreement available in English, which you can use.