Republic of Ireland captain Nathan Collins says the national side are desperate to end their wait for a major tournament qualification but must become horrible to play against if they are to reach the 2026 World Cup.