Can Siri stop the sound after a while?

Yes. Say "Hey Siri, stop Berceuse in 30 minutes". You can say 5, 10, 15 or 30 minutes, or 1 hour.

The sound fades out, then stops. To keep playing, say "Turn off the sleep timer on Berceuse". It works with the phone locked.