After my last post I've done some digging and found out why LibreELEC 10 cannot connect to some networks.
The problem here is that Raspberry Pi 4 WiFi HW does not support Protected Managment Frames (802.11w) right now.
But that is not really a problem on other OSes for the RPi4 including older LE 9, where it does not even attempts to use PMF, which means that as long as the WiFi AP is using PMF in optional mode, it will connect just fine.
Now what is causing the problem: LE 10 defaults to PMF being used every time the AP supports it, ignoring that there is no RPi4 HW support for it.
How to reproduce: Try connecting to any PMF optional WiFi using LE 10 on RPi4.