I believe that you need to set up your custom domain in the Functions app. In particular, there are two settings pages to visit: custom domain and TLS/SSL settings.
On the Custom Domain page you'll enter the www.myapp.app and myap.app domains and verify that you do own them. Your existing CNAME will be fine- the App Service page will let you know if not, and it will request you add a TXT record with the Verification ID provided for you on the Custom Domain configuration page.
Once you have the custom domain setup with your app, you can head over to the TLS/SSL page to associate your certificate with the domain. Since the certificate is hosted outside of Azure, you'll need to get a copy of the private key certificate from GoDaddy and upload it to your App Service. Once the certificate is uploaded, you can associate it with the custom domain you want accessible via https.
There are tutorials for setting up custom domains and SSL in Azure App Services. There are a couple differences when working with a Functions consumption plan. You won't need to change the pricing tier from consumption to one of the ones discussed in the tutorial. In addition, only CNAME verification is available in Functions. Since you are already using CNAME, that shouldn't be an issue for you.
Custom Domain: https://learn.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-custom-domain
SSL Certificate: https://learn.microsoft.com/en-us/azure/app-service/configure-ssl-certificate-in-code