I’ve had a look at the actual database entry for my custom field in wp_postmeta
The meta_value is being stored as an integer rather than as a URL.
I’m having a similar issue. My ACF image field is set to return the URL but when I call the field from a twig template I get back an integer, which I think is the ID number.