1) Do you actually mean "use the DxO Nik Collection of plugins within Affinity Photo", If so which Nik plugin is giving this colour shift? Or do they all do it?
2) When you say you've passed the problem on to DxO, do you mean you've submitted the problem direct to DxO Support via this page:
https://support.dxo.com/hc/en-us/requests/new
If you have not also posted about this problem on the DxO User Forum:
https://feedback.dxo.com/
you should do so. You will get a faster response from the DxO users there than from DxO Support.
3) When you say, "optimised for Lightwave", do you mean the Nik plugins seem to work better in Adobe Lightroom?