Important: #99044 - Ensure auto-created redirect are stored on connected site root

See forge#99044

Description

Long time ago, automatically created redirects were created on the top root page pid=0, which has been changed meanwhile to create them using the page ID of the changed page as pid with forge#91776.

This led to some issues, like permissions during copying and pasting pages.

Automatically created redirects are now stored using the root page ID of the site configurations as pid to minimize side-effect issues and prepare follow-up features.