That game defines a very small stack size for its executable (only 64 kilobytes, the default on Windows is 1 megabyte), which isn't enough memory for ReShade to work with, thus causing a stack overflow during effect compilation.
This can be fixed by modifying the game executable file to allocate a larger stack on startup.
I quickly wrote a simple tool which does that:
download link
.
Make a backup of the executable ("CoD2SP_s.exe") and then drag and drop the original on the tool. It should then fix up the file provided you have full writing permissions to the directory. Btw., the tool works on any executable, so should there be more older games with this issue, it will fix those too.