Can I trigger an automation based on a media_player’s source?

I'm just guessing because you didn't share what you're seeing. However, chances are you're using a device trigger, so you only get a limited subset of options when using it.

Switch to using a state trigger & use the attributes section to set the source you want to trigger off.

EDIT: Ninja'd by @LiQuid_cOOled :ninja: