The big problem with your idea is that Kirk & crew "rid[ing] into the sunset to glorious deaths" would contradict Spock, McCoy, and Scotty still being alive at the time of TNG.They should have just ignored "Yesterday's Enterprise" episode and reshot it with Kirk & co.
A copy?---yes
A cheat?--yes
Better than Generations or Hurley's concept?---YES
Every beat of Yesterday's Enterprise would have been awesome with the two crews.
Talk about a proper send-off. Kirk and his crew ride into the sunset to glorious deaths to prevent a catastrophic war that claims billions of lives.
Just follow the Ent-A into the anomaly long enough to see them kicking some Romulan ass and impressing the hell out of the Klingons, thus ensuring the future alliance.
Escape pods!
Kirk orders the ship evacuated after it has lost all ability to fight and life support is failing. Some crew survives.
Uhura, Chekov and Sulu are killed during the battle in heroic fashion and Kirk goes down with the ship.