Some embedded systems need old databases although one can often get around the requirement by using a programmable database proxy. (eg Businesses are not going to replace an expensive machine tool just because it needs an old database.)

Linked servers tend to be slow. Try

1. writing a program/script to copy the table. Powershell should be adequate.

or

2. run the process from the SQL2022 server and use Polybase.