Does having a lightning rod on top of a church show lack of faith?

No it just protects from lightning striking the higest point and shorting out something that might cause a fire.