fix: Improve config JSON array/object error message and parser

[WillDaSilva]

Closes #7339

[netlify]

✅ Deploy Preview for meltano canceled.

Name	Link
🔨 Latest commit	8bd74b3
🔍 Latest deploy log	https://app.netlify.com/sites/meltano/deploys/63f695cf5fe34b0008cba739

[codecov]

Codecov Report

Merging #7344 (8bd74b3) into main (2ba4720) will increase coverage by 0.02%.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##             main    #7344      +/-   ##
==========================================
+ Coverage   88.82%   88.85%   +0.02%     
==========================================
  Files         293      294       +1     
  Lines       21698    21720      +22     
  Branches     2451     2452       +1     
==========================================
+ Hits        19274    19299      +25     
  Misses       2032     2032              
+ Partials      392      389       -3     

Impacted Files	Coverage Δ
src/meltano/core/setting_definition.py	93.95% <100.00%> (+4.82%)	⬆️
tests/meltano/core/test_setting_definition.py	100.00% <100.00%> (ø)
src/meltano/cli/utils.py	84.39% <0.00%> (-0.96%)	⬇️

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more