RPMs go up but no acceleration and bogs down?

This sounds like you have to check the transmission fluid which will cause the problem you are describing.

Here is a guide to help but we should run the codes as well, I have included a guide for that below:


https://www.2carpros.com/articles/how-to-check-and-add-transmission-fluid

and

https://www.2carpros.com/articles/checking-a-service-engine-soon-or-check-engine-light-on-or-flashing

Please go over these guides and report back.

Took it to AutoZone, put it on the scanner and the transmission is slipping, the power train system P1870 to be exact. What are some recommend steps? Do you think trying the new fluids and cleansers for the transmission fluids would maybe help to see if it just needed a good cleaning or do we need to take it to a mechanic and get the transmission rebuilt?

p1870 Code - Transmission Component Slipping so it seems like the transmission is worn out, but you can try a service to see if you can get a few more miles out of it with a new filter.

This guide can help you with the job:

https://www.2carpros.com/articles/how-to-service-an-automatic-transmission

If not here is how to remove the transmission for a rebuild. Also, this video shows the job being done on a different car, but the process is the same.

https://youtu.be/3vJAojsrfuU

Check out the images (below). Please let us know what happens.