Log Insights rolled out OpenSearch Sql. You can now do this via something like:

SELECT 
  count(*) as req_count,
  regexp_replace(path, '(\/\\d+\/*)', '/<id>/') as regex_path
FROM your-log-group
GROUP BY regexp_replace(path, '(\/\\d+\/*)', '/<id>/')