Yes, The specific page wont appear for guest mode
System-privacy consent plugin disabled -- You will see the pages appearing straight as envisaged if plugin is disabled while being logged in also
Logged in with specific plugin enabled -- As introduced with recent version of Joomla, System-privacy consent plugin enables the user to be redirected first to user profile page as seen currently due to validation flow as quoted above