I have been using TrueNAS core for some years now, and have searched for a 2.5gb solution without luck for about a year. When scale has stable support for 2.5gb I will probably make the switch too.
I have no first hand experience with scale, but I am a long time user of Linux, and will try my best to help you.
The card you mention has a driver for Linux that can be downloaded. It says in the notes on the download page: "1. For Linux kernel up to 5.17."
As I understand it, scale now uses kernel 5.15 LTS. So the driver should work on a normal Linux install.
I do not know if it is easy/possible to install a driver on your own in TrueNAS scale.
If it is easy/possible, then you should be able to use this network card if you install the driver. You will almost certainly need to use the linux command line. Upload the driver to you NAS, be root, and install the driver.
For my own install, I will wait with switching to scale until I know for certain that there is a 2.5gb card that is supported by the kernel itself without any need for a separate installation of a driver. I see almost all AM5 motherboards now come with 2.5 as standard, so I think it is just a matter of time before we can enjoy more speed on our old cables.
If anyone know of a 2.5gb card with native support in the current kernel used in TrueNAS scale, please let us know!