Phones & tablets
First, the good news: your alarm should have gone off. Apple states plainly that Do Not Disturb, the side switch (or the Action button on newer iPhones), and Silent mode do not affect the Clock alarm sound. So something else got in the way.
Check these, in order: (1) Is the alarm actually turned on? Open the Clock app > Alarms and make sure the switch is green. (2) Is the alarm volume up? Go to Settings > Sounds & Haptics, and drag the Ringtone and Alerts slider up. Turn off "Change with Buttons" there so the side buttons can't accidentally lower it during the day.
(3) Do you have headphones or a Bluetooth speaker connected? The alarm can play through those instead of the phone speaker. (4) One more possibility on Face ID iPhones: Settings > Face ID & Passcode > Attention Aware Features can lower alert volume when the camera sees you looking at the screen — worth turning off and testing tonight.
If the alarm still misbehaves after all that, bring the phone to me.