Reserved VM. A Discord bot keeps an open connection (websocket) to Discord all day. Autoscale only runs while HTTP requests come in and scales to zero in between, so your bot dies when nobody visits the URL, which is exactly what you saw.
- Autoscale: websites/APIs that answer requests.
- Reserved VM: things that must run all the time (bots, workers).
- Static: plain HTML/CSS/JS, no server.
- Scheduled: run a script at set times.
Pick the smallest Reserved VM, a small bot barely uses anything. For the match reminders you could even use a Scheduled deployment that posts via a webhook, but then commands won't work.