I am sure if they put SD on the MBA and iMac and CF Express on the MBP that not a soul would be confused that the consumer model got a consumer card reader and the pro model got a pro card reader.
This is not a debate about the merits of SD cards versus other removable media formats. It's about what makes business sense to Apple, which wants to sell the maximum number of computers.
People need to get over this whole "pro" marketing label. Apple makes cheaper computers and more expensive ones. Anyone can choose either of these according to their needs and desires. Some people will be pro or keen amateur photographers, but most will not be.
Apple is selling to a mass market and had added options that it thinks (hopefully after some valid research) will appeal to the *maximum number of people* in order to make the computer attractive to buyers.
I don't think you can deny that *most* buyers of M1 Pro/Max are not people with cameras that use CFExpress cards. Some will be of course, but I would bet that a larger proportion of users will be reasonably affluent technical users who may have a few SD cards in cameras or other devices. Probably the majority of people who buy a new MBP will have no use for SD cards (or any other kind) at all - they just want a nice fast computer.
Plenty of people disagree with Apple's choice of ports, mainly because they don't personally have a use for them, or think it detracts from the inclusion of other ports that they would use. The choice is at least logical, and I assume Apple did some research into what *most* people say they would like and use.
Adding features used by a tiny minority would make no sense - it would please a very small number of people versus offering utility to a larger number of people - thereby making the MBP a more attractive purchase - which after all is Apple's business goal.
If you need something else (CFExpress, CFast, Red mini-mag, Alexa Codex.....), then you are in a small minority and will be expected to provide your own adapters. If you have an expensive camera that needs these formats, then you're rich enough to afford the dongle

SD is the for the masses....