When I worked in bigco as an analyst, the director and even managers were from a different era. The better ones knew excel to some extent but had no idea how to do sql or even excel automation which was a large part of what the analysts were required to do. Part of this is a rapid almost stepwise change in the work that is done, part of it is due to tech companies recruiting from a diverse set of industries.
In other industries like law, finance and accounting, most people start at the bottom and slowly work upwards so the skillset is more of a continuum up the hierarchy so it is feasible that your bosses can still do your job.
It used to be the same in other industries but that is fast changing. For instance, the top level accountants will have been studying at a time where bookkeeping was literally done in paper books...