Interesting article. Thanks for explanation.
I would watch out for unexpected surges causing you to exceed AWS free limits. I don't know AWS, but I would investigate anything that would limit costs automatically. I have heard horror stories.
As you note, you are pretty much locked into AWS. My solution as a PHP person is to host on Ionos for $8.50 (including tax) a month (cheaper plans available). KISS deployment is a git pull, delete a few files and run new migrations. Super simple and reliable. Especially for a lower volume site. And it is extremely portable to an Linux host with cron and git support.