Technically YES. There are all tools needed for that. There are MQTT, OPC, Modbus, ... nodes and there are Node Red UI modules that can help to build responsive UI.
I would say Node Red is a SCADA, but is not called so because it is generally used for none-industrial applications. I know cases where Node Red was installed directly on Linux based PLC and was used as Visualization Web Server.
I do not see any reason why Node Red could not be used as SCADA.
But there is always a but. Since it is not SCADA but rather can be used as SCADA, there are number of limitations and shortcomings. There is not alarm manager for example. It would be hard to create mnemonic automation diagram. There are no tools like pipe, tank, scale, ... all those tools that are traditionally be in SCADA.
On the other hand, if you think philosophically if there would be HTML based SCADA, it might miss all those tools too. The UI uses different technologies than all other desktop SCADAs.
So basically, you can add control or view of any elements of your automation system, but in a conceptually different way to organize presentation.