A Pilot is roughly the same size as teh Ford Explorer and Toyota Highlander -- definitely not a small truck under the usual definitions.
Honestly -- a minivan would probably be cheaper, larger cargo capacity, and more useful for most folks under she really needs offroad or towing capacity...