Answer
The answer is "Atlantis: The Lost Empire". Jim Varney's final film appearance was in this animated adventure film released in 2001, where he voiced the character Jebidiah Allardyce "Cookie" Farnsworth. Sadly, Varney passed away later that year due to lung cancer, making "Atlantis: The Lost Empire" his last on-screen performance.