I'm an ENT fan, but to be honest I can't say I liked the reference at all. In fact I thought it was a crap reference.
Archer was born in approx 2111, the line is said in 2261 (IIRC.) Archer would 150 years old.
McCoy was only 137 in Encounter At Farpoint
, and that the was the 24th Century, and he looked like he was going to die at any minute. So how would Archer be then?
So you just basically killed a poor old mans dog? The man who saved Earth from the Xindi, who helped formed the Federation, who was dubbed 'the greatest explorer of the 22nd Century'?
That's meant to be funny?
I much prefer to go by the bio from In A Mirror Darkly pt.2
, that Archer still lived pretty old, but to 2245 the day after attending the the christening ceremony of the first Federation Starship Enterprise, NCC-1701. And he wasn't an Admiral, he became Ambassador to Andoria, a councilman on the Federation, and eventually President of the UFP.
respect to the guy. Not killing off his beloved pet when he's on his deathbed