I don’t really have an answer but I remember a user recently had a similar problem (with Nobara as the “other” OS instead of Tumbleweed).
os-prober (the module that grub-mkconfig uses to find other OSes) should have been able to find the Nobara install on a btrfs partition, but for some reason it didn’t.
If you wanted to dig deeper, you could try replicating from a terminal the linux-boot-prober commands that os-prober is supposed to use (in the code quoted in my linked post above).
In this case, apparently it did find Tumbleweed, according to the OP. However, the partition for tumbleweed that is shown in his post (nvme0n1p2) appears to be btrfs.
AFAIK with a routine installation the bios cannot use a /boot in btrfs for booting (the btrfs drivers have not been loaded at that stage). This is why for fedora /boot is an ext4 filesystem.
@tbojanowski for the current conditions you should be able to boot tumbleweed from the bios boot menu. It may be necessary to use that exclusively since the bios does not allow booting fedora with /boot in btrfs.
For a final fix you should be able to create a custom menu entry in grub to allow booting from the tumbleweed drive by editing the file /etc/grub.d/40_custom and making the necessary entries there to boot the other OS, but probably would need to use the efi partition on the tumbleweed drive for booting.
Messages from os-prober showing that it found the Tumbleweed partition
Nothing in the GRUB menu for Tumbleweed
Now, once os-prober finds a partition, the next step (per the code I highlighted in the linked thread) is that it calls linux-boot-prober to get further details necessary to create the GRUB config.
So since OP sees the first step happening correctly (os-prober finds the partition) but no GRUB config gets written for Tumbleweed, it seems to be that linux-boot-prober step which isn’t doing what is expected.
In any case though, it’s not that GRUB is trying and failing to boot from btrfs. It’s that the entries for Tumbleweed don’t get written into the GRUB config when grub2-mkconfig is called.
GRUB can boot from a btrfs partition. Though if you’re booting from Fedora’s GRUB (without openSUSE’s patches), there will be limitations, e.g. GRUB2_SAVEDEFAULT won’t work because the grubenv data won’t be written.
Another option, as @computersavvy mentioned, would be to add a GRUB entry that just chainloads the openSUSE EFI.