It seems to me that the responsibility for caring for you falls on Aer Lingus, as they are the ones who caused you to miss your onward flight.
A ticket does not guarantee you a specific seat, so there is no compensation to be had for having to sit at the back. But, with a 25-hour delay, surely there is time to check in online as soon as it opens and select some decent seats?
No airline will ever compensate you for an unused hotel room. That's what travel insurance is for.