For example, in this repository, GitHub Actions for GitHub Pages, I put the workflow status badge with workflow name type URL.
That shows “passing” and is expected behavior.
Also, the path type badges are available like the following:
It always shows “failing”. That seems to be a bug.