I'm not sure there's much reason to be that tied to the chip anymore... When you load up MariaDB on your Fedora box the commands to install it and run your software are identical whether it's Intel or ARM. Apple of all people just like (for example) the Linux community are perfectly capable of writing device drivers for each processor architecture and once that work is done really what else makes a MacOS machine on ARM vs Intel any different than a Linux distribution found on multiple architectures?
Particularly since Apple focus so heavily on positive customer experience I can't help but feel they'll make it as painless as possible. Most likely it's not a concern at all.
How about virtualization? Desktop virtual machine software seems to be a pretty healthy industry on Mac.
The main reason I was convinced to get a Mac was the move to Intel CPUs. I figured if there was a problem, I'd just install Windows, and I even bought a license for Parallels.
Since then I've occasionally spun up some Linux VMs in VirtualBox, I even installed Windows using Boot Camp on my first Mac for a while before deleting it to get the space back, but I've never made serious use of Intel compatibility. It's just never really been necessary, just occasionally useful but not enough to mean losing the option would be in any way a deal breaker.
I do seriously doubt they will move away from an Intel compatible platform, at most if they did then perhaps AMD chips. If Apple took their Macs away from Intel compatibility I doubt I would buy a new one and it would put into question the ability to maintain what software library that exists for the platform.