"Is a CMS built using Node-red even a good idea?"

Well, there are lots of CMS options that are easy to set up and efficient to run. A 1.5GB AWS instance is pretty big. I used to run my own blog in WordPress in 1/4 GB I seem to remember and WordPress itself is considered quite heavy as it needs MYSQL as well.

These days, my blog is run from a static site using Hugo. It is hosted on a free-tier from Netlify with Cloudflare (again free tier) providing a front-end proxy that gives some additional performance, security and analytics. I'm only getting around 350 visits a day at the moment but I have had much higher loads occasionally and performance of the site stays at around A+ without any cost. I use Disqus for comments because a lot of people already have accounts.