Why isn't it just a CM plugged into the bottom of the keyboard circuit board for upgradability... it doesn't bode well that Rasberry Pi's own products aren't using the weird connecter the CM has.
You can buy the connector here: https://uk.rs-online.com/web/p/products/1362374/?grossPrice=...
I agree with you though. RPi appeals to people with a wide range of skills. There are lots of programmers who want to use Pi to get more electronics knowledge, and RPi foundation could make that a bit easier for those people.
(EDIT: I don't understand why parent has been downvoted. A lot of similar devices do use newer more specialised connectors and it can be hard to work out who makes and supplies the connectors.)