It would appear you can play it as a regular Stadia member (non-Pro) just by purchasing Beyond Light: https://9to5google.com/2020/06/09/destiny-2-beyond-light-google-stadia-first-pre-order/