In Drupal 8, when adding an image field in Views it has an additional "URL to Image" formatter which can output the image url easily. I find this feature is great. Back in Drupal 7 it has also a module called Image URL Formatter which do the same. I wish this feature can be added to the core. It should be able to to support image style as well. Please consider adding to Views for future enhancement. Thanks!

Recent comments
@yorkshirepudding, In the end I fixed it by deleting the config/active folder contents, copying the config/staging/ files into config/active, importing the database again and clearing the caches...
Importing the staged config throws an error: another field with the same name already exists
Thanks, I have to go out now, I will try later on and report back
Importing the staged config throws an error: another field with the same name already exists
Hi Francis. Yes, what config do you have in staging for it? You might have configs like: field.field.field_video_embed field.instance.node.page....
Importing the staged config throws an error: another field with the same name already exists