A bit hard on yourself
Perhaps its your conditioning but I do think you are being hard on yourself. IT is an unusual environment because it changes so much all the time.
Take a lawyer. Yes, there are new laws passed each year - but not that many and often with years of warning. But there is only one law. In IT there are many equally valid new alternatives all the time.
Or take an a civil engineer. Brick and iron have the same properties now as they did when man first learned the smelting technique and 'stone age man' is a euphemism for backwards.. There's a reason we call them 'concrete' examples - they are definite, unchanging. Sure, some smarty pants will point out that we invented steel. But that was over 100 years ago.
Meanwhile in IT land there are always new ways of doing old things. We cannot embrace them all. It would be great if we could but its just unproductive. And potentially career threatening. Pick the wrong new idea too early and your shiny new product is going nowhere. Not because the new idea you chose was a bad one but because the crowd sourced alternative idea that won has many more adherent and is, for now, correct.
Years ago I opted to use a JavaScipt library called MooTools. It was great. Then Microsoft chose jQuery and the rest, as they say, is history. By contrast in 2007 I jumped in to the cloud so I could reduce most of the IT department - I suppose, really, re-skill. Despite dire warnings about the terminal dangers of the cloud, the benefits were so obvious. Fortunately, I chose AWS. I write 'fortunately' not because I believe they have some fantastically unique service but because the crowd made the same choice. I'd like to say it was great foresight but it was a toss up between AWS and some outfit in California I can no longer remember. The Californian's problem was lack of geographical spread and one day I had a problem accessing their service because the infrastructure provider, Level 3, had a bad day - nothing to do with the Californians directly. That was it.
One way of looking at your issues is that your (and my) personal traits make us antagonistic. Another is that we have to make choices, sometimes with long term consequences, between alternatives are that are really identical. We make a choice and then advocate our position. There is no viable alternative. One is to capitulate to everyone else's view but if you are going to capitulate there was no point in making a choice in the first place. Being a thoughtful introspective person,you would not have made a choice in that instance so the scenario does not arise. The only reason we advocate is because we see a reason, probably parochial, that one alternative is better than another. In other circumstances we sit firmly on the fence waiting to see how it pans out.
I'm like this with containers at the moment. I don't really 'get' the need for containers. Of course the evangelists will brow beat me with their reasons but I don't see a business case for learning this technique that other techniques I already know don't work at least as well. But I recognize this is a parochial perspective. I probably do not yet have a use case that fits the container problem (though that doesn't stop the evangelists harassing me).
NoSQL is another. Don't get it. I get the need for denormalization. I just don't get why a 'special' database is required. A few year's back I was willing to listen so attended a MongoDB webinar (it could have been a Crouch webinar - those identical choices again). The webinar was lead by a guy who read English at uni and wrote poetry. No, No, No. I wanted to hear from CS PhDs about why my optimized and distributed relational engine was not up to the task and why my years of experience querying SQL databases for BI apps in global businesses was going to be consigned to history. The use case presented was CraigsList. Not their main database - that continued to be held in MySQL. Apparently CraigsList were looking at NoSQL for their archive databases so they could change the structure of the main database more easily - or something. Seemed to me to be an interesting application but not the world changing use case for NoSQL.
So give yourself a break. The adults can try to tell us to get our house in order but that's because they live in more deterministic houses. We know the adults will not do any better because IT is more like social media and we know how successfully the adults have managed to rein in social media.