even in trucking many new trucks are coming with automatic transmissions - likely with some sort of manual up/down in case you need to pick a better gear
They have been for decades really, it's just least common in OTR hauling because in that application the manual gearbox still has an efficiency advantage. They are probably most common for construction equipment because the automatic gearbox offers tangible advantages there. There's a promotional video from Allison which is pretty easy to find whose tagline is something like "continuous power" about how the benefits of their transmissions which are able to make shifts under full power, which is true; the heavy ones are full planetary gear designs and they are as convenient and reliable as the day is long. These gearboxes also don't conveniently feature more than six speeds, but on the plus side, Allison tends to give two overdrives on highway use transmissions.
The problem with consumer-level automatic transmissions continues to be reliability. A lot of the modern many-speed automatic transmissions have only a single-gear limp mode which is only suitable for getting them onto a trailer, where older transmissions often used to have two-speed limp mode, and some of the new transmissions cannot limp at all without a functioning TCM. I see that as a big drawback. Belt-driven CVTs are also infamously fragile, yet also dominant in low-end vehicles.