It is a known issue, but I don’t think it is being seen as urgent.
Medium - VFX Creator - Custom Niagara VFX or custom Sprites do not show in game. was reported in April, and they said they are opening an incident for it in August:
But no updates since then, which is a bit surprising for an incident.
Maybe the best we can do is keep voting for the issue above.