I consider both issues found so far (susceptibility of the internal buck converter and this IO problem) pretty "severe" to consider it for any serious use and can't see how it can be sold as is as a part for any commercial product.
For hobbyist use, as long as you follow the workarounds, that should be usable.
I would have thought the other way around. Professionals embedding it inside something else, which they are designing, should be capable of designing so as to avoid the problems. It's non-ideal, but then so are transistors!
It's hobbyists who are far more likely to run into problems. Especially as they probably don't read the manual in full.
Very much a matter of perspective. Sure, as a professional you're more likely to understand the errata and implement appropriate workarounds, but (usually) the end result is much more critical than any hobby project.
If you kill a $1 MCU as a hobbyist or some parts of your board because you didn't closely follow the errata, that's not a big deal. Forums will just flood with topics about this and countermeasures will be spread relatively quickly. Sure, it may (or not) give this MCU a bad rep in the hobbyist market, but the silicon bugs are there already anyway and the RPi will have to deal with the hobbyist market appropriately if that matters to them.
As a professional, even though the workarounds seem straightforward, that still doesn't look good and doesn't inspire confidence. I have actually used the RP2040 in one commercial project with no failure so far. It had no real issues other than a meh ADC. Potential latch-up, though, is bad. I hadn't seen a single modern, commercial MCU (seen that on ASICs for student projects though for sure) with this kind of issue in a long time.
The workaround will often imply an increased power consumption, which may or may not be a problem. (But it may.) It also pretty much prevents using internal pull-ups, so requires additional passives. Finally, while the workaround is straightforward and shouldn't leave much surprise, that's still a problem that may be lurking in ways that haven't yet been completely identified.
The buck converter thing is even more concerning to me, as it's not (at least as far as I've personally read) clearly explained in details. It looks like an aggravated susceptibility to EMI, which obviously could be caused by other external factors than the orientation of its inductor. That doesn't look good. Of course, you still have the option to use an external rail (if I got it right), but that means having to add an external regulator. That's a pain.
I don't know how sales and uses are all going to work out for this chip at this point. I'm a bit curious about that.