That action works fine here in Chrome (KM 11, macOS 14), so I have no idea what might be going on. Do you use any Chrome extensions that might be managing how new URLs are opened?
No, not using any extensions that might interfere with this.
I've managed to get my desired outcome through a different set of steps.
There is some sort of bug that interferes with Chrome when a new tab and a specific link is to be opened. I've found it to be a bit finicky but considering I have several Chrome windows running different user profiles, it tough to zero down on the exact cause.