Firstly - if people are paid they are not carers - they are careworkers.
Secondly - let's keep words like "age" "infirm" and "frail" out of this please - disability and longterm illness are not necessarily age-related. No matter how many elderly people have become so sick or disabled that they need meals on wheels etc, their age has nothing to do with them needing that support.
Thirdly - if you think that the amount of training given to careworkers is shamefully low, consider that given to carers; often none, love or at least guilt/duty is supposed to be enough. Maybe topped up with what can be gleaned from the internet or a book.
I'm not saying that careworkers are adequately paid, trained, or supported - for every few who are, I'm sure that many more are not. However, if you really want to address where the money goes when it comes to care, look at the agencies. Book somebody to come into your home to help you eat, bathe, shower, or dress and you might well be charged £18 an hour. Meanwhile, the careworker will be lucky if they see even half of that money.