> Carplay sometimes randomly starts playing music when I get in the car, other times it doesn't.

Android Auto does the same thing for me, despite having auto-play disabled. One possible explanation I've seen online is that some infotainment systems send an unsolicited "play" signal to your device. For Android that seems to mean it will send "play" to the most recently used app that supports audio playback.