This is yet another API that can be used to load libraries.

What was the need for it?

Hard to say.

As far as I can tell only one module on Windows 10 imports it today.

Under the hood, it’s just a wrapper for a LoadLibraryExW which in turn relies on LdrLoadDll. Still, if you code sandboxes you may want to capture it.