The /function/ of these stupid naming schemes, despite whatever explanation is proffered as to their origin, is exactly as you have pointed out:

It takes time to learn all this lingo, which makes people tend toward 'specializing' in that ecosystem, which makes you more hesitant to migrate or attempt to interface with some other software ecosystem with its own separate lingo.

It also serves to make you feel stupid for not understanding it, basically in the same way a group of friends laughing at an in joke that you dont understand makes you feel like a lesser member of the group.

Lots and lots of programmers, db admins, etc, are basically low social skills or on the autism spectrum, so keeping people feeling low on the social pecking order makes them easier to boss around, makes them more likely to accept ludicrous and technically inefficient solutions, accept being paid far less than what they are worth, etc.