@Edwin if the DVD player was active in macOS it would appear as shown in the following screenshots:
View attachment 4841 Hackintool Peripherals
View attachment 4842 System Information > Disk Burning
View attachment 4843 System Information > SATA
Which SATA port do you have the DVD connected to in your system?
The DVD device will be working at 1.5GB not the full 6GB that a SATA port can provide, this is normal. The drive should work with any functioning SATA, SATA2 or SATA3 cable, because of the native speed of the drive.
There are 6 x SATA3 connections on your motherboard, as shown in the screenshot from your motherboard's user manual:
View attachment 4844 SATA ports on Asus Prim X470 Pro motherboard
As far as I can tell these ports do not share PCIe lanes with the 2 x M.2 connectors. So they should all be available even when the 2 x M.2 connectors are populated.
This is what the Manual says about the M.2 connectors:
View attachment 4845 M.2 connectors on Asus Prim X470 Pro motherboard
You need to check that the DVD device is active and enabled in your Bios.
You need to check that the SATA and SATA Power connectors are fully seated in the motherboard/PSU and in the back of the DVD device.
You may need to try swapping SATA cables to see if the one you are currently using is defective.