Do we need spatial index for point type geometry in SQL Server? If yes, how Tessellation and grid selections work in point type geometry?

I'm trying to create some TTL indexes in azure cosmosdb collections (mongo API), these collection's elements are all string or integer, but when I use the index spec { "expireAfterSeconds":...