It won't be a bios setting, and since your particular adapter is designed for NVMe, it won't be able to do it without hardware modifications. M.2 ports determine what mode they run in based on particular pins being tied to either VCC or ground, so any passive adapter that can do either mode would need to have jumpers or dip switches, and I don't know of any that do.I could never get it to work in either m.2 slot; tried a couple different brands of adapter and switched the bios settings for the m.2 from nvme to sata but made no difference; these adapters aren't passing sata through or there's some special board setting that's missing. I've never seen the adapter Asrock mentioned for sale anywhere either.
Theoretically, if you're good with a soldering iron, you could cut a trace and add a jumper on the adapter to modify an NVMe adapter into a SATA one. Personally I'm not sure if it's worth the effort since you're only getting one more SATA port out of it, but it's an option. See this document for which pin you'd need to modify if you want to try going that route: https://www.congatec.com/fileadmin/...Pinout_Descriptions_and_Reference_Designs.pdf