Those old applications might not support the Cloud. You could try and see.
You might be able to use the Image Capture app on your Mac to import media to your Mac. Or use the import procedure that iMovie '08 describes in its Help menu. Also, you should be able to export photos and videos from iPhotos (File/Export) to your desktop, and from there drag them into iMovie.
Your software is really old, so I am not entirely familiar with what options were available back then. You might consider getting a new computer if that is in your budget. With a 12 year old computer you are nearing the time when the drive is going to fail and you will lose all of your data. So, if you haven't done so already back up your computer to an external drive, perhaps using Time Machine, to avoid a catastrophe. If you get a new computer, don't get one running Catalina or none of your legacy software will work with it.
-- Rich