The extension is available for those tiers, yes. The extension is an enterprise feature at this time. The main issue I could see you running into are the entity limits for connections.
As for deprecation plans, there is no planned date for this feature to be deprecated. Although, as an extension, it is possible the features would be rolled into the core product at some point (like I said, there is no planned date for this, but just a possibility).