Republic of Ireland side branded ‘worst in decades’ by former striker Tony Cascarino after embarrassing defeat to Luxembourg