Since this guy basically says "no" to anything that allows any modification does he cancel out pilot abilities that allow mods? such as the aforementioned pilots and the ability of autothrusters?

Yep.

In the simplest terms, what you roll is what you get. Look at the results of your dice and then pick them back up, same as if you just decided not to use any tokens or abilities.