Yes, if you download DLC on Xbox Live, all profiles on that console can access it.
This applies to Xbox 360, Xbox One, and Xbox Series X|S.