He's largely missing the point.
Medicine advanced when we started cutting open bodies. Neuroscience is about getting beyond black box testing of brains, and understanding the underlying mechanisms of how a brain works, and integrating that knowledge with behavioral observations.
It's probably true that in many studies employing brain scans, they provided little value. So what? It's the basic reductionist program to do white box testing and come up with an integrated model. Neuroscience shouldn't be a separate magisteria from psychology.
In this post, Jesse Marczyk argues that psychological neuroscience research often doesn't add much value per dollar spent and therefore is not worth the cost.