edit: I don't see it as the browser second-guessing me as much as following what I'm already trying to do in the first place. I don't pin a tab if I don't actually want to keep that specific page open, and taking an action to preserve a state that I opted into isn't going around my specified intention, but following it.
1. Let's imagine I have pinned a dashboard url in my bank's website. After some time, I go back to it, it sees I've lost my session, redirects me to the login page, and bam, that login page open up in a random, un-pinned tab. How is that a good experience?? You might say I should pin the login url, but no, after login I always want to get to a specific dashboard page.
2. In my view, pinned tabs are not for specific urls; that is what the toolbar is for. Pinned tabs are, for me, simply a way to have the most important tabs you are working easily available. And that makes sense, because the set of tabs that are most important changes a lot from time to time. I frequently have hundreds, probably a thousand, tabs open. If I have to pin every single url I'd like to go back to, I'll quickly run out of room in no time.
So let's say depending on what I'm working in this month, suddenly I find myself using Github a lot, or Notion. Then it is far easier for me to open some of my pinned tab and just navigate to the new urls I want, rather that have to close each of them , then create new pinned tabs, and hope that if I click on something on the page that is minor, I will not be rudely pushed into another tab.
Summary: I think you are using pinned tabs for what the toolbar was designed for.
Maybe the difference here is that I don't ever have more than maybe a dozen tabs open total (including the half dozen pinned ones). To me, it seems more that you're using tabs for what browser history was designed for, and that you're using pinned tabs in a way that doesn't make sense unless you are using tabs in that way.
From my experience I want to pin tabs because I simply want a set of tab available for use that remain visible when I scroll through a lot of tab headers to the right.
It's very annoying to be on a pinned tab, navigate to even just another server on the same root domain, and suddenly be pushed to another (un-pinned) tab. Even if navigate to a totally different url, I do no want to be pushed to another tab.
The enforcement of the url remaining the same should be done by myself, not the browser trying to second-guess me.