Question : Does Managed SF support certificate common name (with a wildcard)?
If you are talking about the cluster certificate, then no. The Cluster certificate is completely managed by Azure.
But, the application certificate is owned by the customer.
To provide more clarity, the certification information provided in the 'clients' section of the template is for client certificates. These are certificates in customer's possession and can be used as credential to access the cluster. They don’t need to be installed on the cluster, the cluster only needs to know their definition and use those to authenticate the client connections.
The cluster certificate, on the other hand, is managed by Azure. When connecting to a managed SF cluster with Service Fabric PowerShell, customer needs to query the Azure managed cluster resource to get the details about the cluster certificate, and then use that as connection parameters. Please see Connect to a Service Fabric managed cluster for how to do that.