Shock footage captured the rockstar struggling with a song before slumping to the ground mid-set - before things got even weirder