After my research and further queries, both azure-sdk-for-.net and Azure community teams responded and confirmed that there is currently no way to get the pricing list information from Azure CLI and azure-sdk-for-.net.

Here are the links to the posts:

https://github.com/Azure/azure-sdk-for-net/issues/47644

https://learn.microsoft.com/en-us/answers/questions/2137589/get-skus-always-returns-null?sharingId=8101BBDD04DDA53D

I will update this answer with any new findings or responses from the Microsoft-Azure teams.