pgsql-http has been out awhile and works fine, but is synchronous. It will hang your trigger until your http responds or resolves.
pg_net is Supabase's newer async approach. It is either alpha or beta, not sure without going to look. You can glance thru the issues and see if it is stable enough for your use. It is used by Supabase function hooks.