Basic resource deposits (energy/mineral/science) do not give any bonuses to the habitat. They just add the corresponding district.
Strategic resource deposits create a deposit in the station that gives you the resource even if you don't have the tech (zro, living metal, motes/gas/crystals), while the mote/gas/crystal deposits also enable you to build that many number of buildings. Since those buildings produce base 2 of the resource, it's usually a multiplication of resources.
Raw material districts are generally not worth it. Gravity world focus have a 25%, while habitats have a 15%. Habitats are generally better for industrial sites, leaving resources to the worlds.