Lancashire Thunder complete first Kia Super League win despite Loughborough Lightning's late charge