Hunting for rare furniture in 'Animal Crossing: New Horizons' turned into one of my weird little hobbies, and the 'tremendous statue' is definitely the kind of thing that makes me squeal when I spot it in 'Nook's Cranny'. In my experience it's not a regular sight — shop rotations favor seasonal items, common furniture, and the odd special piece, so stumbling on a stately, oversized statue feels like finding buried treasure.
From what I’ve seen, that statue is more often a one-off or limited-time piece that shows up unpredictably. It’s way more common to get unusual statues from visiting Redd’s ship when he’s in town, from Gulliver or Bottle Shops, or by trading with other players who hoard rare items. That said, I have caught a 'tremendous statue' in 'Nook's Cranny' once after a fresh daily reset; patience and daily checks helped a lot.
If you want to hunt for one, I’d recommend checking the shop every day, visiting friends’ islands, and following a few reliable trading threads to increase your odds. I still get a jolt of joy seeing one on the floor of the shop — feels like the island gods smiled on me that day.