You can ditch the AWS part actually. I was originally planned to query the API directly from the Pico W. However the performance was not good.
You can self host the part that on AWS to anywhere else easily, using Lambda is purely because of the free tier thingy.