Yes for the wound, and no for the skin around it. The whole answer is in keeping those two apart.
On the wound. At a wound care center, after the wound is clean your provider will apply a dressing to keep the wound moist, which promotes healing, and help prevent infection. The same goes for pressure sores: a dressing protects against infection and helps keep the sore moist so it can heal.
On the skin around it. The other direction is just as important: keep your dressing and the skin around it dry. Try not to get healthy tissue around your ulcer too wet from your dressings. This can soften the healthy tissue and cause more foot problems.
Wound bed moist. Surrounding skin dry. Those are not in conflict; they are instructions about two different surfaces. Reading them as one contradictory rule is the most common way to get this wrong.
There is a point of tension worth naming honestly. One of the dressings often used first for a diabetic foot ulcer is a wet-to-dry dressing. It is applied wet and allowed to dry so that it lifts wound material off as it is removed. That is not a moisture-retaining dressing. Which approach suits a particular ulcer is a clinical decision.
Everything else stays the same: keep the ulcer clean and bandaged, cleanse the wound daily, and follow the dressing routine you were given.