All RRSP home buying plans/arrangement are stupid.
I rolled my home mortgage into my wife's RRSP many years ago and it worked for us.
.
https://www.morningstar.ca/ca/news/185513/what-kinds-of-mortgages-can-i-hold-in-my-rrsp.aspx#:~:text=The%20main%20advantage%20of%20putting,%2C%20however%2C%20is%20the%20cost.
A self-directed RRSP can hold a mortgage on either commercial or residential Canadian real estate. Such a mortgage (first, second, etc.) is a qualified investment for an RRSP provided certain conditions are met.
The mortgage must be administered by an approved lender under the National Housing Act (which includes most financial institutions) and the mortgage interest rate, and other terms and conditions must reflect normal commercial practices. In addition, where the mortgage is a "non-arm's length mortgage" (i.e. the borrower who is mortgaging his or her real property is the RRSP annuitant or is related to the annuitant), the mortgage must be insured either by the Canada Mortgage and Housing Corporation (CMHC) or by a private insurer of mortgages. The mortgage insurance requirement ensures that in the event the annuitant defaults on his or her mortgage, his or her retirement savings are protected.
The main advantage of putting your own mortgage in your RRSP is that you can pay yourself (through your RRSP) a higher rate on the mortgage than you may have been able to earn on the short-term income and cash instruments currently in your RRSP. Perhaps the biggest drawback, however, is the cost.