It must be said that the SDK etc. is intended for the RP2040 rather than for the Pico. The real "gotcha" is that the crosspoint switching between peripherals and pins is subdivided, so UART0 can appear on only a small number of pins, UART1 on a different group and so on. That's not too bad, until you have something like the Cytron board that I've got which has put an ESP8266 on pins which can only be connected to UART0... meaning that any serial output that would normally be on UART0 has to be moved to either UART1 or USB.
That is why I rate the RP2040 positively from the hardware side.
I presume that you're talking there about the "classic" RPi plus Raspbian or whatever they call it these days: you /are/ aware aren't you that you can set up other named accounts? I'm not sure that's any worse than the Ubuntu philosophy where the standard is (or at least was) to have a root account which can't be logged into directly.
Of course it can be changed. But messing around with various Linux configuration files is a pain. In addition, some changes need to be made in the startup script files. The more that it looks different in different distributions (files and their location in individual directories).
VSCode has a Trojan that I'm still characterising, don't use.
I am not using VSCode. I generally hate pseudo-programs written with scripting languages (allergic to MS Teams). In particular, I hate monster applications written with JavaScript (including those based on Electron). It works poorly with OS. The performance is also not the best, not to mention ergonomics. In addition, some activities related to programming the microcontroller must be performed in VSCode by typing commands in the console. This is not a step back - it is a step back 30-40 years. It is all the more surprising that RPi Pico was intended by the creators to popularize programming and electronics, and in particular to encourage young people to learn them.
I got used to IDEs such as Delphi, Visual Studio (standard) or NetBeans quite quickly (NetBeans sometimes it is a bit slow, but you can work). They really make life easier. The Foundation could use NetBeans as an IDE, which is free. There are modules (plugins) for it that support C and C++ (I tested, they work).
Python... I loathe the language, but the last few years have demonstrated that it's serviceable for tacking stuff together. If you have to criticise anybody, I suggest directing your ire at the people who think that a good way to design a user interface is to embed Javascript and a browser engine into a program.
My (very critical) opinion about Python was shaped by its use. The first languages I started programming with were (chronologically): ObjectPascal, Pascal, C++, C, Java, PHP, JavaScript, C#, Python. This is probably why I think JavaScript and Python (PHP too) are crap. It is different with people who know one language, such as Python or JavaScript. When a person gets used to the comforts, then an attempt to use something primitive is painfully felt.