You can even see that with the option enabled there are 26 queries, without it is only 21 queries.
PS: I see that the execution time is reduced from 7.0 ms to 5.9 ms indeed, but the requests increased.
Yes, this is exactly how the option is supposed to work. When optimising for a "distant database" (i.e. a separate database server), Q2A combines many queries into one. This is faster for that setup because there is an additional cost associated with every query made.
When optimising for a "local database" (i.e. when MySQL host setting is "localhost" or "127.0.0.1"), that additional cost does not exist. So running multiple smaller queries is actually faster. The other advantage is that queries are simpler and more easily cached by the MySQL query cache.
So in other words, the "QA_OPTIMIZE_LOCAL_DB" option is not about running fewer queries, it's just about reducing the query time.
However, the main thing I notice in your image is that most of your queries are in the theme section. That means they are almost certainly from plugins or a custom theme. This is outside of Q2A core so the distant database option cannot help with those.
It looks like the queries are not taking much time, so I don't think there is anything to worry about. But it might be worth looking to see if one plugin is making too many queries.
