Is it normal for companies these days to solely rely on Amazon RDS backup without another backup strategy?

Depends on the criticality of data. If you have truly business ending or catastrophic business results from days loss, you should be using off site as well (Amazon will also do it for you) and possibly a secondary off site not with Amazon.

For smaller less important shit you probably can't afford to do all that.