Think about it. The SSD1306 displays the "frame" in its internal GDRAM at a certain scan rate. The Cathode Ray Tube in an old TV has an electron beam that scans horizontally drawing each line down the screen.
OLEDs and TFTs do much the same thing. You can do a single scan or an interlaced scan. A TV used an interlaced scan.
You can write to the GDRAM faster than the GDRAM is displayed by the regular Frame scan.
For example. Your OLED or TFT might display at 70Hz or so. A human eye sees a steady picture.
An MCU can send a whole set of 128x64 pixels in about 1024us with 8MHz SPI or 23040us with 400kHz I2C.
The SSD1306 specifies max SPI=10MHz and I2C=400kHz
Your ESP32 can achieve faster SPI and faster I2C speeds. In practice, my SSD1306 will work faster than the spec.
Motion pictures will look quite smooth at 30 FPS.
Clearly you can send 1000 frames a second to the GDRAM (via SPI) but you would never see all 1000 frames.
Even with I2C you can get 41 FPS. My SSD1306 will (just) work with 800kHz I2C i.e. 83 FPS.
You would need to use a faster SSD1306 scan rate to display separate frames.
David.