I believe that every once in a while even the most serious TV series needs to take time out to explore aspects of the characters that have nothing to do with any of the running plot lines. This, in a nutshell, is what this episode is about - and has been accomplished with a great deal of humor.
I highly recommend this episode, but don't expect to learn anything about the Goa'ulds, Tokra, Tollan, Replicators - or even technology for that matter. It's a fun episode.
The premise is helped by the fact that the experience was shared by two main characters. If it had been just one, they might never have accepted the unlikely situation as fact.