Hmm, I can get this to work in ArcMap:
As per @Wendy Harrison's remark: are you absolutely sure that the data source you are using doesn't have some invisible hidden characters, e.g. like a new line?
The fact that some records do work, but others fail, is indeed usually an indication of invalid characters, the most likely being the & "ampersand" and < "left arrow bracket" characters, as these aren't allowed, but I am still wondering if there are more that may raise issues?...
To be honest, I haven't yet tried this in ArcGIS Pro, so don't know if there are any issues or bugs there I am yet unaware of.