You can cast it directly to timestamp_ntz.

Sample:

select parse_json('{"summary": {"disconnectTimestamp":"2024-03-21T20:19:57.398Z"}}'::string) as test_json,
test_json:summary.disconnectTimestamp::timestamp_ntz as final_timestamp

Result

2024-03-21 20:19:57.398