Well if it was "at the bottom of the pool" then it could be inside of the pool or outside of the pool, but "in the bottom of the pool" kinda specifies that it inside of it, but both work
Not really? If you say at the bottom it just means at the bottom of it?