I currently own both vehicles, a CX-5 NA and a CX-9T. Short story, if I had my choice I'd drive the CX-5, but the CX-9 is better for hauling around family.
The only reasons my CX-9 stands above our CX-5 are: room, turbo engine, a few options (that are available on my CX-9 that my CX-5 was not...