San Francisco and the Bay Area in general is great. I used to live there and Dh, oldest dc (4) and I went there for 2 weeks a few years ago.
BUT you need to stay away from the main tourist areas/downtown. Those are rubbish and there is a lot of homelessness and deprivation.
I’d recommend looking for an Airbnb around the Inner Sunset. This means you have easy access to Ocean Beach and Golden Gate Park. You can go to the Haight (which is also a bit rubbish but you have to see it). You can visit the more touristy areas if you really want but you aren’t stuck there. Chinatown and Japantown are interesting. There is amazing Mexican food in the Mission. You’ll also be able to get to the zoo via public transport.
There’s a vintage arcade near Pier 39, which dd loved. And we just had lots of picnics in parks with playgrounds, took some nice lunch food and a bottle of wine, relaxed on a blanket and dd played. You can take the ferry to Sausalito. If you hire a car, you can drive to Napa, the Redwoods, Montecito, down to Monterrey to go to the aquarium. You could even go out to Lake Tahoe, though must take into account weather conditions and book accommodation well in advance.
It is really a lovely city, but you just have to stay away from all the tourist crap. It’s just like people who go to London, only go to Trafalgar Square, Buckingham Palace, and the M&Ms world and then complain it’s so overcrowded and commercialised. You’re better off going and staying and enjoying the real SF that people who live there love.