Aiven Postgres supports the open-source version of TimescaleDB.
But Timescale Cloud is the only hosted service where you can get the full TimescaleDB experience, which includes our community and enterprise features (eg interpolation, data retention policies, continuous aggregates, data reordering, etc). [1]
It also includes special machines types and plans more suited for time-series data that we co-developed with Aiven.
It is also the only hosted service directly staffed by the TimescaleDB development team.
If your Aiven database is having Timescale architecture problems, your support contact is someone working for Aiven who would need to turn around and reach out to Timescale about the bug (or suggest that you do so.)
If your Timescale Cloud database is having Timescale architecture problems, your support contact is someone working at Timescale who can just call over the guy who wrote the code with the bug in it.
(On the other hand, if your problem is with the Aiven backing cluster, it'll presumbly take slightly longer for Timescale Cloud to resolve, given that they'd have to bounce that forward.)