How often are those preppers actually trained to take on several armed attackers?

It's not often. Having ten firearms and a million bullets doesn't help you much if you're a semi-crazed loner who vastly overestimates your abilities and usefullness