After spending some hours to resolve this issue, I was able to make it working again in the Bitrise. I noticed that they mark the existing Apple code signing in each project as legacy and recommend managing it in the workspace settings.
After adding my App Store Connect API key there, it started working again with ad-hoc distribution. In my case, I created a new API key, however I hope this helps other devs.
Topic:
App Store Distribution & Marketing
SubTopic:
App Store Connect API
Tags: