This paid DLC adds a new water-based realm, a challenging new enemy faction (the Dark Tide), a new Valorplate (Mobius), and roughly 10-15 hours of additional campaign content that takes place after the main story.
When you download the Godfall Ultimate Edition repack from DODI, you get exactly the same content as the legitimate version: Godfall Ultimate Edition -DODI Repack-