I don't think it is so absurd. Many roads, as well as bridges are closed to big rigs.

Some fuel deliveries are restricted by time of day. Nukes?

There are some things like telephone poles that require long trailers, but it is unclear if the load that was being carried was one of them. Weight laws sometimes require distributed wheels, but carrying the load forward in the video would indicate that greater weight was being applied to the cab than the trailer, and thus not likely an overweight load, and more likely a larger trailer than necessary.

There is no reason why shipping companies can't use hubs on the edge of town and transfer loads to appropriate trucks whenever possible, especially for palatalized loads. There are a few hand-loads that are difficult to transfer, but that is a minority of the business.

Had a trailer half the length been used, with closely spaced rear axles, or even a flatbed truck without trailer, the truck driver likely wouldn't have had to pull left so far, and perhaps would have even turned into the right turn lane/area. And the cyclist would have had more of an ability to react.