If you're running into Media Offline problems, check these things:
1) are the drives listed correctly in User -> System -> Media Storage?
2) are there any potential filename conflicts with the source media?
3) be aware that almost all H.264 files do not have accurate embedded timecode, so that can be a potential issue (particularly combined with #2)
4) make sure the drive read/write permissions are set correctly
5) on Mac OS, I would strongly urge you to avoid exFAT, which has problems with Sonoma & Sequoia (strictly my opinion). We generally see better performance with HFS+ (for spinning drives) or APFS (SSDs).
6) check the file path on the Media Page for the missing files and see if you can force a relink. Highlight the files, right-click, choose RELINK MEDIA, and then choose the correct source folder.
7) if the files are H.264/H.265 10-bit, be aware that they will only play in Resolve Studio. (There's quite a few codecs that only play in the Studio version.) For a lot of reasons, highly-compressed H.264/H.265 files are not ideal for post. We generally transcode everything to a better format like ProRes 422 or DNxHR SQX, embed better timecode, and give all the files unique names.
8 ) it's possible only your render cache has gone offline. To ward against that, re-render the cache or just delete it all and then go to the deliver page and try again.
The key is to check the MEDIA PAGE. Look at the rows of media and check where the source drive is. Worst case, relink it all. We try to confine all the media for one project to one folder, so worst case, we'd lasso all the media files, right-click and choose RELINK, and choose that one folder. "In theory," it should just work. Sometimes, just closing the session and re-opening it forces Resolve to go out and check the drive and file paths, and then the session is fine again. And as always, make sure you have enough available space on all connected drives.
Finally: on a Mac, check to make sure you have the latest Pro Video Formats update:
https://support.apple.com/en-us/106396