Could the Enterprise-G be making an appearance in the near future?

The TNG sub has an old article on Yesterday's Enterprise, "the episode that saved Next Generation."

The episode saved the show from low morale.

Anyways, SNW could be on the verge of doing a 1:1 homage of this "greatest hits" story:

Tomorrow's Enterprise

Their Season 4 finale could cast Pike's Enterprise in the role of the Enterprise-C time traveling to a dystopian future for a short time.

Could they meet the Enterprise-G, or even the Enterprise-E under Captain Worf?

There are some exhausted "fans" who have argued that Star Trek is a tired franchise now, and has especially become unoriginal.

TOS has 3 recycled plot episodes out of 79.

In turn, only 19 TOS episodes were reused in the Berman Era.

TNG has 13 recycled plot episodes out of 176.

DS9 has 8 recycled plot episodes out of 176.

VOY has at least 31 rehash episodes / recycled plots / copycats out of 172.

ENT has at least 16 rehash episodes / recycled plots / copycats out of 98.

There was still a high degree of originality in the older shows.

Newer Star Trek shows are still mostly original.

Many of us don't like the Lost "mystery box" writing format that was introduced in Discovery and Picard, but that controversial writing style appears to have minimized the number of recycled plots. Both shows are at least 90% original.

Lower Decks is mostly original, due to its introduction of animated comedy into the franchise.

Prodigy appears to be mostly original, as well.

Strange New Worlds gets more interesting.

There is a tendency in Strange New Worlds to split its episodes between over the top campy humor, on the one hand, and homage episodes to "greatest hits" TOS and even TNG episodes, on the other.

Unlike VOY and ENT, however, the producers are at least transparent on this online in their post-streaming interviews. Furthermore, at least 30 years have passed; if these episodes had aired 10 years ago, they would have been panned under the Recycled Plot trope.

Of the 46 planned episodes, no less than 10 are 1:1 retelling stories of "greatest hits."

Not 100% sure but in S3 E4 I think in the flashback scene towards the end where Picard is talking to cadets, Jack has it next to him.

Last seen being sipped by Sisko in DS9.