You want to boot Operating Systems - Ubuntu or Windows -, not "drives" and in any case it would be partitions...
Your line of thinking has been carried over from the time computers had BIOS and drives used MBR ("msdos") partitioning type. Even then not entirely applicable although there were indeed advantages in having different bootloaders in different drives for dual-boot.
You need to understand the different boot processes of BIOS vs. UEFI.
Until recently, there were only BIOS/MBR.
In those systems BIOS starts, does POST, reads the bootloader in the MBR of the drive set as the primary boot device (failing that it will try others in order if available). That bootloader "points" to a system partition from where all the remaining boot process and OS loading takes place.
Only one bootloader can be installed in the MBR so, when installing a dual-boot, Grub would be installed instead of the Windows bootloader (we can't use that because it only boots itself or other Windows if present) and would boot both Ubuntu and Windows.
So, with a single drive, we would necessarily work with Grub only. If for some reason Grub failed (e.g. Ubuntu has been deleted) we wouldn't be able to boot Windows either unless we reinstalled the original Windows bootloader booting from Windows media into the recovery/repair environment.
With two or more drives we could keep the Windows bootloader intact. We would simply change the boot drive order to another one where we would install Ubuntu and that drive only would have Grub installed, with the ability of booting Ubuntu and Windows in other drive. Pleased note, we would always be booting from the boot drive's MBR into both OSes regardless of where they were installed, using Grub. But because we left the Windows bootloader intact in the original boot drive we could easily change back to that one in BIOS and boot Windows directly.
So, even with BIOS/MBR, the boot process doesn't necessarily starts in the same physical drive where the OS we were booting was installed (and both Windows and Ubuntu installations can have partitions in multiple drives) and that's why I say your reasoning is applicable to old BIOS/MBR machines but only partially, you're focusing too much in physical drives.
== Most of the stuff above isn't applicable to UEFI ==
... and you have UEFI and, because you also have a NVME drive, the Legacy/CSM route isn't an option for you (you don't want that anyway). In your case all OSes must be installed in UEFI mode.
How is it different?
For starters, bootloaders are no longer limited to the very small space of the MBR - with any modern OS in BIOS/Legacy (and MBR) only the first stage of the boot process happened in MBR, everything else would have been read from /boot if using Grub or the Windows system partition if using the Windows bootloader) -, bootloaders are enow saved in the ESP - EFI System Partition -, a small FAT32 partition labelled "EFI" and different ones can co-exist peacefully, which is a huge advantage and brilliant.
So, now the boot process goes like this: UEFI starts, does post, reads bootloders from the ESP and finally releases control to the OS set as default. Again, and more than ever, where the OSes are actually installed isn't relevant, the boot process is always started in the EFI partition and then the selected bootloader does its thing.
Typically we'll use Grub as before which in turn can boot Ubuntu or chainload to the Windows EFI bootloader which in turn boots Windows. But now, even with a single drive, we are just a UEFI setting change away from booting Windows directly with the ability to change back to "Ubuntu" (which is Grub and can boot Ubuntu and Windows). Many UEFIs conveniently allow overriding the configured boot with a one time boot menu (F12 in yours). Very useful to boot installation media.
More information about UEFI and dual-booting: https://help.ubuntu.com/community/UEFI
With all this I hope it's clear why I said you're thinking it wrong. Your system requires additional steps in preparation for installing Ubuntu. Again, you need to make sure the drive where the EFI partition resides is "visible" in the Ubuntu live session (booting from a USB stick) but this really isn't related to the UEFI boot process and requirements commented above, it's a specific situation of your computer. If not visible then yes, you'll have to change the mode to AHCI (and the Optane drive will probably show up as usable too but the caching feature will be lost. Before doing it you must install AHCI support in Windows or it won't boot in AHCI mode; also disable Fast Startup - i suggest you google both - in Windows and Fast Boot in UEFI. Disabling Fast Startup and Fast Boot should be done irrespective of the RAID/AHCI situation, to be clear.
Why is it important for the Ubuntu installer to "see" the original drive correctly? Because otherwise you won't be able to setup a proper dual-boot, you would be limited to the UEFI settings to select Windows or Ubuntu and in order to do that you'd need to change two settings in UEFI each time you want to change OSes. Without the original drive "visible" to the installer it will install the bootloader to a new EFI partition in the only drive visible, the added 1TB SATA drive. It works to boot Ubuntu only and that is if you change the boot drive priority in UEFI and then - a different setting - select "Ubuntu" as the default OS (it will be the only one because UEFI is reading the EFI partition in the new drive and that one contains entries to Ubuntu only). If you want to boot Windows you'd have to do the reverse, change the boot drive priority back to the original internal NVME drive (it will boot Windows only because that's all it has, the Ubuntu EFI bootloader was installed elsewhere). This is really very far from ideal.
So, the proper way is to have the Ubuntu EFI bootloader installed in the same EFI Windows is (we already know they can co-exist, two or more, by design), keep the exact same boot drive priority and, in a different setting, select "Ubuntu" instead of "Windows bootloader manager" (the installer itself should change this setting but sometimes it doesn't so we have to do it manually). Again, this will boot Grub first allowing you to select either Ubuntu or Windows (and at any time it can be changed back to "Windows" resulting in booting Windows directly, UEFI is so much more convenient).
You may or may not need to do manual partitioning (the "something else..." option in the installer). Usually not if you're just adding a new blank drive, the "Install alongside..." option should a) pick the unallocated space in the added drive and partition it automatically, for your convenience (nowadays it will take all the space in a single / (root) partition) and b) detect the existing EFI in the original drive and install the bootloader there. You can, of course and as mentioned, do a different manual partitioning like with a separated /home, etc. but in that case you must also select the EFI partition (in "something else") to use and with EFI type (it won't give an option to format and you wouldn't want that obviously) along with all your other partitions for Ubuntu.
In summary, dual-booting in your computer isn't easy or trivial but not that hard either, as long as you prepare it correctly before installing Ubuntu. And also strongly recommended by our resident expert @oldfred , UEFI update -and- firmware update (if available) for all the SSDs involved and particularly for the NVME, before anything else, from Windows which also benefits from this updates. And, I'm afraid it may have other peculiarities I'm unaware of, but at least the basics are covered, I hope, in this much larger than usual post.
Bookmarks