An appliance is the ultimate lock-in and enterprise companies LOVE them.
That "if you have the tech talent..." qualifier is the big one, though. I see very few companies who recognize how to attract and retain that talent level. IMHO, out of the more than 200 companies I've consulted at or sold deeply enough into in the sales cycle to see enough of how their sausage gets made to form an opinion, probably no more than 1:100 do this. So we end up here, where most companies are content to hire well below that level, buy closed tech stacks, and then play support-tag while users sit unhappy. Plays well politically, but it's a mess for delivery service levels.
The reason enterprises can't hire that kind of talent is because they don't want to. The reason they can't retain that talent if they do accidentally hire it is because that kind of break-fix resolution
1) doesn't happen that often so the people get bored
2) is frowned upon by management because those people have actual jobs to do
and
3) is the entire reason they pay a support contract to their vendor
And $50k/yr in support costs is a lot cheaper than hiring the world's best DBA, world's best Linux resource, world's best Java programmer, world's best infosec analyst, world's best architect, world's best SAP resource, the list goes on and on.
The job of enterprise IT isn't to be the best at anything, it's to be stable and predictable.
Even Linux's adoption was more with not paying UNIX licenses than caring about any kind of openness.