As for expectations for NTFS support, I was using Linux with NTFS drives on an old laptop for many, many years and never had such problem. I never saw this coming.
I'm using too something like this, a dual boot (Win11 & Xubuntu) PC, and I had issues with the NTFS partitions, become better after I disabled hiberantion option in Windows. And yes, for the partition what I want to be "simple" and always usable in the both, I'm using exFAT. Mostly this linux-NTFS issues coming after a "dirty disconnect", like sudden disconnect/power down, what couldn't be expected in the case of the HDD assembled in a laptop.
Not sure what an issue means for you, but it is without a doubt an issue for me, as my current setup is not usable, due to the HDD randomly just dissapearing from LE with no reason, no that I can think of.
To simplify more this, I think the NTFS issue isn't LE related. It's in the linux kernel. So I think the right place for this could be somewhere in a linux development forum, kernel section. And about if it could be "resolved" soon or not... just try to think from another side, to report an issue in a Windows forum as you have difficulties with reading EXT4 linux partitions and you don't have full suport for it...
You have concern about EXT4 and how to read it if your RPi with LE become defective. You have 10TB data on an external HDD, did you think ever, enough a little bigger mechanical shock and that disk could became defective, without chance to recover any data from it? I learned before, from my own bad luck and defectiv HDD, to don't keep important data in a single location.
Sorry, but exists issues without a simple (or at all) solution and this probably is one of them.