We are not able to see the "Show Workflow" related list option for some change requests

OOB behavior once the workflows are older than 180 days they are not retained.

By default, the table cleaner on wf_context table removes workflow contexts after 180 days it has been completed. This is the reason you don't see "show workflow" UI action on these change requests.