I don't have experience, but the fact it runs I'd rule out a direct fuel or direct electrical issue. It sounds like it's possibly a bad sensor, low fluid, or the Trans has internal issues. Did you check the fluid level? Is it a reddish color or brown? Does it smell burnt? There could be a variety of possible problems. You could check google for similar issues with pilots or Odysseys as I think all of these vehicles share a similar Trans.