A damning report into the impact of the Covid pandemic on care homes has criticised Government failings for allowing the virus to "spread like wildfire".