Hi Colin,
In order to use the images from Experience Cloud Assets in Activities, you need to integrate Adobe Target with Scene7. I have lately done this and it works perfectly. When the Activity gets saved, the image is uploaded to Scene7 server and its URL (src) gets updated accordingly.
You can find additional info following the links below: