Can you actually ride the rockets?

Yes. Pretty much any grenade/rocket launcher projectile, it's just only rockets usually have large enough collision that makes it easier to stand on it