Why after two failed attempts was the third Home Rule Bill a success?

Simply, because the Parliament Act. When the ouse of Lords rejected Lloyd George's budget the Parliament act was enforced removing the Lords power to veto. They were the ones that had opposed the Home Rule in the past as the Liberals could pass things in the commons due to superior numbers. Now Home Rule was just a matter of time.