How to retrieve a file or image from a content type?
Yes, this is an annoyance, no doubt.  Drupal stores the uri using a public:// streamwrapper. Thankfully, someone has written the code to resolve that into a full url that gets attached to the file object for you whenever one's loaded: https://www.drupal.org/project/full_url_file_info