When is it useful?
When a company uses many subdomains and wants simpler certificate management.
Scope
Wildcard covers one subdomain level and does not replace SAN for multiple different domains.
Deployment
Protect the private key carefully, because one certificate covers many services.