Hundreds of vulnerable Midlothian residents will have to pay for access to sports centres after the council scrapped free sessions.