Yes your shopify site would stop working if your dns is setup wrong.
my works shopify site has A record pointed to a shopify ip address and CNAME for www. Pointed to shops.myshopify.com
This is seperate from DNS MX records used for email.
If you are changing DNS to a new provider then you need to make records are correct on new provider.
I would ask shopify support for advice on correct settings.