I just had a look at the Hawke's Bay Club/Community Rugby fixtures list for 2024 and it looks like most of the bigger clubs still have a Seniors, Colts & Div 3 team, plus there's also the Brad Weber Cup (Under 85kg) which effectively makes 4 tiers.

I don't really know how that compares with rugby in England/Wales/Scotland as the terminology might not be like for like. Club rugby in NZ is basically community rugby - its in the towns and suburbs and each region will run their own competitions. Next step up is typically the NPC, which is where the best player's from each province's club competition are selected into a representative team, and then obviously from there the best players go up into Super Rugby.

The NPC has been getting a bit weird though as the best NPC players that don't make Super Rugby will be overseas playing professionally somewhere as well (MLR, Japan League 1 etc) so might not actually end up playing much or any of the club competition before making the representative team. Some Super players will play club games as well, even though the seasons overlap a bit - I think Nonu and the Savea boys have all played a Super game on Friday then a Club game the next day.

The community game is definitely struggling here though, even where there's plenty of players the difficulty is finding coaching, referees, and people to help staff the grounds etc.