Cast string to timestamp remaining work

What is the problem the feature request solves?

https://github.com/apache/datafusion-comet/pull/335 added initial support for casting string to timestamp, but the feature is still disabled by default. There are some follow on items to implement before we can enable by default:

• Add support for 3 and 5 digit years
• Testing with try_cast and ANSI
• Add timezone support (see advice in https://github.com/apache/datafusion-comet/pull/335#issuecomment-2091930125)
• Passing all fuzz tests
• Updating compatibility guide

Describe the potential solution

No response

Additional context

No response