I thought that was a weird Discourse design decision, but I just checked Chrome now and middle clicking links there open a new tab as expected.
Even if you allow the pop-up it ends up opening in a new restored window rather than a new tab. Right clicking and selecting “Open in new tab” works, but I shouldn’t have to do that.