I have spent many hours on this and am really struggling to resolve this script
I would like to rename the folder AND the file and then move it to the movie folder but I can only get it to rename the folder and then move the untouched filename with it
The format you're using now will most certainly change the filename. And all the files will end up in Your Movie Pool folder.
If you drop disk folders. Or if you force folder mode when dropping files then it'll treat folders as single units. But by default it'll always process video files.
Maybe you could add some screenshots? See video tutorials to get started and see how its supposed to work.