Yes, faster and depending on the TYPE of array you configure or that the device supports (TYPE of RAID array must be supported by the device AND the motherboard.) it might also offer much faster speeds and redundant copies of data so that in the even one drive fails the data is still intact on one of the mirrored drives.
I don't know about that specific product though. Looking at the user manual and FAQ for that product, there is basically zero information offered as to how to setup and configure anything on it. There are also no drivers or software available for it on the ASUS website that I could see. I'd recommend looking closely at that to make certain it will work for you.
The other issue would be, since it's intended for RAID arrays, you're likely going to lose some storage capacity. Generally RAID mirrors drives to increase speed and ensure redundancy, but that means that for two 500gb drives, you get only 500gb of storage space as both drives will contain the exact same information. If you actually need 1TB (For example) then you are better off with a non-RAID option or just using a single 1TB SSD.
For storage purposes, I can't really see the need for NVME speeds unless you are often transferring extremely large files from one drive to another on a regular basis. Even then, if you're OS drive is going to be M.2 nvme and you are using a standard SSD like the Samsung 850 EVO, those speeds are already going to be incredibly fast anyway. Less expensive too.
Four 500GB Samsung M.2 drives plus the cost of that PCI card is about $1250.00.
Two 1TB Samsung 850 EVO SSDs only comes to about 600 bucks. True, the M.2 drives are faster, and in RAID would be even faster than that, but the tradeoff for a drive meant primarily for storage probably isn't really worth it. But maybe it is for you. I do some work, probably nowhere near what you do though, with video and 3D graphics, and for me it seems like the data is almost instantaneous even with regular SSDs and I don't even have an M.2 drive in use for the operating system yet. With that factored in, everything gets even faster.
I really think you'd be fine with an M.2 OS drive and normal SSD's for storage/working files, but of course that's up to you. Your needs, and wallet, are likely different from mine.
Also, regular SSDs can be configured in RAID as well, increasing their speed and redundancy. Without the need for an add in card.