[Variant] Support typed access for numeric types in variant_get

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
`variant_get` supports extracting elements from partially shredded & perfectly shredded arrays.


**Additional context**
Relates to #8087 