A noodle hole is a man who is weak and limpy, as the form of a typical noodle is. The person has also a large vagina / anal entrance because he likes to be fucked in the ass, generally.
Person #1: Man, that dude is such a noodle hole!
Person #2: Yeah he cannot even stand up straight! bet he got f***ed in the ass last night!