Source: I run a SaaS business for gyms and have spent 1000+ hours talking to gym owners about their priorities...
You do cost the gym money every time you go. But only after a certain point (anything more than light use) and if you go at peak times.
Basically, the space you take up at peak time is another membership they can't sell because of potential overcrowding.