Am on Android 14 (started this with 12) and never had any issues with the URL loading in the proper tab.
Can your Firefox offer you the choice to open the link in either a normal tab or incognito? On my phone you pick one or the other in settings and always opens links in that type of tab. But I’m still on Android 11 for the moment so maybe that has something to do with it.