Car is shaking and will BARELY accelerate?

I have a 2007 Honda Pilot and on my way to baseball practice it started shaking/vibrating and it would take forever to accelerate up to 30 mph but once it did, it would jolt and then it would seem like nothing was wrong with it. Then I would stop at an intersection and the car would die and then when I turned it on again, it would again take days to get up to 30 mph, then jolt, etc. Then as I pulled out of the parking lot at the field, it BARELY was able to back out of the spot and I had to keep restarting it and trying again like 4-5 times. Then when I got on the road, it did the same stuff as mentioned earlier.
Now I know its impossible to give me a full explanation over the internet, and I'm obviously going to take it in, but it would be great to have an idea of what the hell is going on and possible costs for possible solutions!

I would check for loose plug wires, or any loose wires.

At least you won't get a speeding ticket

Sounds like it upshifts but won't downshift. If you can shift it manually and then down shift it manually, you may be able to drive it there, but AAA will be the best bet. Sometimes a noisy VSS can freak a system into a false reality. Ask the service department at Honda, they will know. Other sensors out of range can mess with it too, or the computer itself. You could run the codes on it but don't erase or disconnect the battery till the tech has his data.

My guess is a voltage leak in one of your spark plugs. So it's misfiring one of the cylinders. To check for voltage leak in a wire go in a garage turn the lights off start the car and get a water mister spray bottle spray over the lines you might see a little voltage jump from the wire to the water of you see that you have a voltage leak and change the wires. Change the plugs too while your at it can't hurt it

It's most likely something electrical because it jolts and comes back like nothing is wrong. It could be anyone of the sensors acting up. If you can read the codes, or take it to some place like Auto Zone where they can read the codes for you, then you might find out what the trouble is, like what sensor (if it is a sensor) and fix it yourself. But since sensors can be expensive, I wouldn't advise buying any parts like that unless you are sure of what the problem is.

It could also be a problem with one of the ignition coils intermittently shorting out. I don't know what kind of engine the Pilot uses, but if it is a six cylinder then it most likely has 3 ignition coils, one coil for two cylinders. So if one of the three coils is going bad, it will effect two cylinders and that could cause loss of power and strong shaking of the engine. If the trouble code(s) indicate that two particular cylinders are misfiring and both those cylinders run off of the same coil, then I would suspect that coil. But you could just remove the plug wires from the coils and check the condition inside the boot and make sure they are normal. Make sure the plug wires are not frayed or damaged in any way. You might even run your engine in the dark with the hood open and look for any stray sparking from the coils or plug wires and spark plugs. If the spark is leaking off somewhere you can often see it in the dark.

So yeah, if the trouble codes show that there are just two particular cylinders misfiring then I would suspect the common ignition coil or associated plug wires. If the trouble codes say there's random misfiring then it would have to be something common to all of the cylinders and not just one coil.