The greatest quarterback of all time couldn't hide his excitement and fear when he got on the water vehicle