Most times it's a worn out transmission. Necessitating a rebuild or replacement. Have a local trans or auto shop to diagnose the issue,. not a chain shop, to give you some options.
Search Ford Explorer Sport Questions
Ford Explorer Sport Experts