"works fine" is related to the post Win10 build 1903 problems. The changes made by Microsoft in the audio stack rendered the X-Fi products inoperable. The card was detected, kinda working, but no sound was being output, no audio settings were available. OpenAL complained that no hardware or software sinks were detected - or something along these lines. Latest builds fixed that, hence that "works fine" line.
Yeah, I've read the old unreal forum and it's exactly that, and they're also referring to my old post on the LOTRO forum. I even should have this video somewhere, which is referenced in the topic title, haha. And this is not simply an older version - that's the whole other branch where they have changed the whole hardware acceleration part of the driver. And they did that only for Titanium and Titanium HD. And that's when the bug was introduced - but only on Titanium.
As to the source for Windows XP, well, uuh, you see, the source is me 😜 Well, I mean, it's difficult to find anything now with that new fancy Google search, and X-Fi Titanium + Windows XP wasn't the most popular configuration. However, I was very active EAX proponent during those days, filed lots of reports (going often under the name of Jeph) and tested lots of system configurations. From what I can remember, this whole Titanium BSOD story was due to the way they implemented X-Ram on the PCIe SKUs, and that the older way of addressing it (the way it was done during the PCI era SKUs) was causing the system crash. Hence the new driver branch and the aforementioned bug.
Yes, Windows Vista/7 was more at risk (more like, the BSOD was guaranteed) and in Windows XP it only happened under very specific circumstances (the game must had been using the native hardware OAL implementation) - and even then it had to be a very demanding OpenAL load (oh, and also either 2+ core CPU or HT CPU). And as you know, even the games that have such an implementation, often fall back to DS3D under Windows XP - again, D&D Online/LOTRO engine is the prime example - hence little reports of those. If you're still up for sources, try looking into Unreal 2 + titanium + BSOD + Windows XP, as this title was using way more sound sources than u1 and ut, had native implementation and also defaulted to it (I think).
Again, all this is esoteric because you don't need Titanium in a retro rig. For one, it would definitely have a PCI slot (and most likely won't have any PCIe).
For another, when you go for OpenAL games, you'll most likely jump into the Windows Vista/7 era or very close to it. When you go there, there's no reason to run these dx9/dx10 games on a retro rig. They're perfectly serviced by a more modern systems + dgVoodoo (and 4k resolutions, 120fps+ modes, etc, or a CRT monitor). At least that's how I do it.
The only remaining stone is EAX. And for that you'll need a real creative product that's still working on modern systems. And that's not Titanium, or at least not for now - is what I'm on about 😀
Edit: and I mean, that's great if a Titanium already works in your retro build. The crash is very rare and very specific - and most of the times you can simply switch to DS3D and often maintain EAX compatibility. So it doesn't really matter. It's just, knowing all that and keeping in mind the PCI slot availability in a retro rig, it's difficult to recommend this specific card to someone, who's going for a new retro build. The PCI variants also have way more fancier options with way more functional front bay panels, remote controls and even a cool breakout box. It was the Creative's heyday.
MB: Asus P3B-F 1.03 (2x ISA)
CPU: PIII-S 1.4GHz/VIA C3 800MHz
RAM: 256MB PC133
Video: GeForce 4600Ti/Voodoo 5 5500/Voodoo 3 3500 for DOS Glide
Audio: SB16 OPL3 + Audigy Platinum Ex
OS: Windows 98