It's quite strange, but my friend having the same issue with a SanDisk CFexpress card and reader on an M2 MacBook Pro managed to somehow change some setting that enabled Auto Ingest to work for him.
Unfortunately though he cannot tell what setting or even where did he change on his system to enable Auto ingest. The only thing he can confirm for sure is Auto Ingest prevously not working on his Mac and now does work as expected.