1993 Honda Accord Transmission question

I have a 1993 Honda Accord Wagon EX that had it's transmission burned out. It can still go in reverse but cannot move forward. Also per the mechanic
there is a "clunk" sound when the engine is started and he states there is a problem with the rod and that the engine needs to be rebuilt in order to fix this. He mentioned something about a piston issue.
My question is whether it would be worth fixing. How much would work like this cost ideally? Thanks!
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
Add image file

Motorsforum.com is a website by car enthusiasts for car enthusiasts. It is not affiliated with any of the car or spare part manufacturers or car dealers discussed here. All logos and trade names are the property of their respective owners.