A well-known Aberdeen-based oil executive has claimed the UK North Sea industry’s leading trade association is becoming “increasingly irrelevant”