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

It's not free of risk (regional datacenter outage, account termination), but for a lot of companies the above are acceptable risks compared to the cost of managing this yourself.