Are you accessing this site through HTTPS, or does your storage account require access through HTTPS? If so, you cannot map a custom domain to a azure storage static website directly, you must go through a CDN or Application Gateway. Your current setup should work for HTTP.
Also, make sure that you can get the website without issues when accessing the storage URI directly.