I’m not sure what could be preventing Node-RED or the HTTP request node in particular from getting the entire file, but could you try using an exec node with curl -X GET '<url>' – just to see if it has the same problem?
To the best of my knowledge, Node-RED should be able to handle up to 5MB files, so I am wondering whether or not there is a limitation on the HTTP request node itself.