Characterising the molecular line emission in the asymmetric Oph-IRS 48 dust trap: temperatures, timescales, and sub-thermal excitation