There are several issues with your current implementation:
Missing animation logic - You're creating static points but not animating them. You need to implement useFrame to create the ripple effect.
Outdated attribute syntax - Replace attachObject={['attributes','position']} with attach="attributes.position".
Camera positioning - Your camera at [100, 10, 0] is likely putting your view outside the area. Try [0, 30, 80] for a better angle.
Performance - 500×500 points (250k vertices) is extremely heavy. Start with 100×100.