A presidential visit to a supermarket amid a cost-of-living crisis was supposed to garner public support, but ended up feeding suspicions the leader is out of touch