Red Gate SQL Prompt in Visual Studio not working?
Unfortunately SQLPrompt works on the connection to a database and not the database project. If you deploy your DB then SQLPrompt can pick it up the schema.

Its on the backlog as a research item currently https://www.red-gate.com/products/sql-development/sql-prompt/roadmap.

If you want project based intellisense then you need to disable SQL Prompt in VS