I don’t think he’s in any danger with Rand Paul supporting him.
To be honest, I don’t think what Rand Paul says will matter to the people of Kentucky if they get thoroughly sick of McConnell.
Other than maybe Sarah Palin, I pay no attention whatsoever to another politician’s endorsement (and I live in MA where it wouldn’t make any difference in reality anyway).