I currently have a watermelon plant growing in my greenhouse. Am I crazy, trying to grow a watermelon in a container in zone 8 (the north-west of the UK)? Maybe I am, but god loves a trier. It may be difficult, but you can grow watermelon in pots, provided you make the right choices.
Those decisions include picking the right variety, container, and soil. Then there is the need to give the plants the right amount of sun, water, and nutrients. It is tricky, but not impossible if you are willing to put in the effort.