My organization doesn't have serverless SQL enabled, so I'm not able to try that out. But I did try a query with a wildcard operator on a different table and Pro warehouse and it worked like expected. Looks like it might be an issue with the table itself.