While the meta tag is commonly referred to as robots meta tag, the name attribute can contain different user-agent values. The specification define the global default as robots which can be combined with a second meta tag specifically for Googlebot. Consider the following example:
<meta name="robots" content="index, follow" />
<meta name="googlebot" content="noindex" />
Google Search Console URL Inspection will declare this Excluded by ‘noindex’ tag which is in line with the specifications.