Vayne didn't go insane in the end. I think he realised that his end was near, so he wanted to die a death suitable for him: in battle.