I've successfully migrated the site to a new Drupal version. I've been on Drupal 7 for several years but supported ended a while back, and when I had some time this weekend I worked through the upgrade.
This was the first upgrade where I could use ChatGPT -- it was very helpful.
The site now runs on a new EC2 instance, with new monitoring and automatic scripts. I stopped using Amazon RDS -- it was overkill for which I needed and too expensive. Instead I'm back at running everything on a single EC2 instance, website and database, and it's working well.