Maybe but this is unexpected if you need to restore from a backup..

I'm more interested by the fact that it apparently didn't work this way before Tahoe.

> This is pretty much how it's suppose to work...

No, it's not, and that's not how it ever worked in macOS 26.3 and earlier.

This change was introduced in 26.4 for some reason.