I'd start by trying to add all the different paths to

  cffi:*foreign-library-directories*
  cffi:*darwin-framework-directories*

and if that doesn't work for whatever reason, patching the library definition in cl-sdl2 https://raw.githubusercontent.com/lispgames/cl-sdl2/main/src...