ENH: json_normalize accepts JSON with str and bytes input

[arthurlw]

• closes ENH: json_normalize should work with JSON #61006
• Tests added and passed if fixing a bug or adding a new feature
• All code checks passed.
• Added type annotations to new arguments/methods/functions.

[mroeschke]

Thanks for the PR but I would be -1 on this feature. We recently deprecated accepting JSON-like strings in read_json so this would go against that API consistency.

Additionally the data preprocessing logic here appears straightforward enough to be done by the caller

[arthurlw]

Thanks for the review! I was unaware of the deprecation, but I understand the concern about API consistency. Will be closing this for now