First, yes, Apple should believe that an M2/M3 Extreme would be better than any CPU AMD can make for the Mac Pro.
Using a CPU with many slow cores designed for data center use will not beat any Apple Silicon that is 2x Ultra for macOS users. It'll look good in Cinebench though.
Second, Apple does not want to support AMD and Nvidia products in addition to Apple Silicon. It's not as simple as slapping together PC parts from Newegg and call it a day. You need to write drivers, support them in first-party software such as Finalcut, and provide years of support. All of these things cost money, time, and resources. It also makes the codebase for macOS much more complicated in the long run.
Third, AMD + Nvidia does not satisfy the unified memory model. This is the model Apple is going for. It has huge advantages in performance and applications that support it.
Lastly, AMD CPUs and Nvidia GPUs simply don't support a lot of features that Apple Silicon can. IE. Using the neural engine for extracting objects from photos. Using ProRes encoders. Using the secure enclave. Using image processing acceleration. Even if these parts can be replicated with AMD + Nvidia, Apple would not want to. Not for the Mac Pro which is a niche.
Apple employees are probably itching to get rid of support for x86 CPUs and AMD GPUs in macOS. Speaking as a software engineer, there is probably a ton of code in macOS and first-party software that is something like "If Intel CPU, do this. If Apple Silicon, do this.". I would want to delete this code asap.