The triggering event components for custom blocks which is "minecraft:on_player_destroyed" didn't execute the event if you are in creative mode, when in survival mode and adventure mode this component can execute the event properly.

I believe this is a bug because every components is supposed to work whatever gamemode you are in!