If you create a separate user, with the same iCloud account, then yes, they will be merged. However, my idea was for people who have both an iCloud library and a non-iCloud library and they want to be able to work with them independently. Switching between those with Photos is a pain and it’s error-prone, compared with just switching users.