A Saintly Switch (1999)

This made-for-TV movie was part of the revival of "The Wonderful World of Disney" in the late 1990s. David Allen Grier plays Dan Anderson, the over-the-hill quarterback for the Washington Redskins. He preemptively quits before getting cut from the team and soon he and his wife, played by Vivica Fox, and their kids are headed to New Orleans, where he will be the new quarterback for the Saints.
They move into a creepy old mansion that used to be owned by a "great sorceress" as their flaky neighbor tells them. Besides suffering from the move to a new city, the kids have to endure their parents' constant bickering and are worried they're going to get a divorce. Mom and Dad seem to be at a constant impasse because she thinks all he has to do is play "dumb football games" and he can't understand why she likes to spend her time painting pictures: that must mean that taking care of the house, the kids, and him can't be too hard, right? 
Then the kids discover a secret passageway to the attic where all the previous occupant's spell books and magical supplies are still laying around. The sister discovers a spell to force two people get along better by making them transmigrate their souls into each other's bodies. Of course they're sure this will solve their parents' marital difficulties so the kids cast the spell, the parents switch bodies, and much hilarity ensues. 
Despite this being the umpteenth incarnation of the "switching bodies" concept, this turns out to be a decent little Disney TV movie. Some of the scenes with Grier and Fox (who whupped up on Uma Thurman as Vernita Green in Kill Bill Vol. 1) are pretty funny with the wife now in her husband's body trying to master the basics of football and with the husband slouching and scratching and drinking 48oz big-gulps of soda while in his wife's body.
Of course the secondary plot involves how neither parents really noticed how the daughter wants to play football and how the son really hates sports: when he sees one of the street performers in the Quarter, he breaks the news to his dad/mom/whoever-is-in-whose-body-then that he wants to take up tap-dancing. The climax of the movie involves the wife giving birth and the  husband leading the Saints to the Superbowl though, technically, this film is NOT classified as science-fiction. Eventually souls are switched back into their proper bodies with lessons learned and greater understanding achieved all around.
But by far the biggest punch line of the whole movie is that it was directed by Peter Bogdonavich. (Guess the bills have to get paid somehow after squandering all the money you made from the classics early in your career and going bankrupt.)
Not a lot of the production took place in New Orleans, but there was more than mere second-unit coverage, as the principle actors were filmed driving around the French Quarter (and coming into the city over the Crescent City Connection, which is the optional scenic route you take when driving from D.C.)