Dynamic Holy Sites needs a be started on a new save to work, it can't be loaded onto a current save. It also needs to overwrite all the vanilla faiths in common\religion\religions, which those faith mods will also try to mod (and need to mod for them to work). Load order isn't a reliable way to determine how the game loads files from different mods, it's primarily done by alphanumeric order of the file names, only when the filenames are the same does the mod load order decide which file wins. You could try on a new save, but if you can get Dynamic Holy Sites to work with it it'll disable many of that mod's features.