[CI] Replace check-dependabot hook with more robust option

[jbampton]

Replace the live-fetch validator with python-jsonschema/check-jsonschema's check-dependabot hook, which ships the schema bundled with the package — fully offline, no network at runtime, no flakes:

I am closing the old PR since we found a better way to do this see the discussion below

apache/sedona#2866

Replace check-dependabot hook with more robust option:

apache/sedona#2987

refs #12932

refs https://github.com/apache/shiro/blob/27bf09470eca422ebf05a165532282b26ef73dd4/.pre-commit-config.yaml#L219