Absolutely keep going. It doesn't matter if you enjoy it or think you are benefitting in the near term. It's not about that so much it sounds. Right now it sounds like it's about demonstrating that you are accountable and you want to explore how you could make your life better and heal your relationships with your son, your grandson, and family. Try different meetings, a women's only meeting, online meetings, etc.
The reality is that AA may not be for you. It isn't for everyone. It's not for me personally as the mindset just doesn't work for me. But while you are going and demonstrating how much you want to change and be accountable, you can also start exploring other options for support with your drinking. There are other approaches out there that have a different philosophy or a different set of practices or mechanisms for support. You can do both until you find what works for you.
Ultimately, you have to want to get better and you have to be ready. You might not be both of these things yet, but if you wish you were, then to an extent you can try to 'fake it til you make it'. Go to the meetings. Find support. Reach out to a therapist or a sober coach and have some sessions. Speak to your GP about what support there might be. Just keep doing whatever it is, something, until you start to feel better. Going to AA may not be a joy at the moment, but it's not going to make things worse. And it at the very least, shows your son how much he matters to you and how much you do want to change.
I say this as someone who is NC with her mum - I never needed my mum to be perfect. But I did need her to work hard to heal the things she messed up. What caused me the most pain was not what she did to fracture our relationship to start with, but how little effort she put into doing the things I asked her to do to sort herself out and repair things between us and create a safe space so she could have a relationship with my children. It sounds like it would mean a lot to your son if you gave it a go. You can't get sober for anyone else. It does have to be for you. But in the meantime, while you are trying to figure out how to get there, there's no reason not to explore all the options you can.