Hi Faiza,
First of all, congratulations on thinking about getting more education, that’s rarely a bad idea! I see GIS continuing this path toward automation, for sure. This has been going on for years, and GIS Analyst/Specialist jobs I see now almost always want you to have some level of knowledge about scripting or other programming. It’s just a fact; GIS is computer-based, so it goes well together with any other software that allows it to work better or faster. However, I don’t think the need for people who understand GIS and what is behind the scenes, like geodesy, coordinate systems, data editing and manipulation, etc. will ever go away.
As for 3D underground, that’s useful and is already happening, as with buried utilities networks. If you have a local scene in ArcGIS Pro (as opposed to global), for example, you can tilt to see what’s underground.
Lastly, Esri is in most of the nations on the planet in some form or another. We may not offer as much data in some areas, usually because of what has been created, and how it’s shared (or not).