unfortunately, the workshop in this game works the same way as everything else in this game - very badly. Therefore, if you want to play a map from the workshop with a friend, he will not see it.
the map can be found in the steam folder - steammaps\workshop and search by the number of the map 3663077229 and then throw the .tga and .map files along the path C: \ Users \ YourUserName \ OneDrive \ Documents \ Command and Conquer Generals Zero Hour Data \ Maps \ Map_from_Sleep (you may have a slightly different path to the folder, without OneDrive, the main thing to know is that it is on the system drive, in documents, the folder where your saves for games are stored).
In the game itself, you need to select the local version of the map, not the workshop version. If only the workshop version is available, you can unsubscribe of this workshop work in steam—it is not mandatory.