I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this!
Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer. Accepted answers show up at the top, resulting in improved discoverability for others.
Issue: Privatelink for blob storage is not resolvable, but the public link is resolvable - unable to use private endpoint for storage account
Cause: Customer shared - We have found that for our Private DNS Zone the Virtual Network Link was not configured for the VNET in our testing subscription. Someone had erroneously linked the VNET for the testing subscription to the Private DNS Zone in our production subscription.
If your issue remains unresolved or have further questions, please let us know in the comments how we can assist. We are here to help you and strive to make your experience better and greatly value your feedback.